Believe is something you do in church. J
Check the parameters..if default is set the date should change..(it does it for me). From: [email protected] [mailto:[email protected]] On Behalf Of Gary Ossewaarde Sent: Wednesday, August 21, 2013 7:36 PM To: [email protected] Subject: Re: [mssms] Report Subscription I believe so. It runs every day of the week. It's delivered by E-mail, Normal Priority, includes link and report as MHTML. From: Johan van Dijk <[email protected]> Reply-To: "[email protected]" <[email protected]> Date: Wednesday, August 21, 2013 1:31 PM To: "[email protected]" <[email protected]> Subject: RE: [mssms] Report Subscription Are you using the default values check marked in the subscription's report parameters.? From: [email protected] [mailto:[email protected]] On Behalf Of Gary Ossewaarde Sent: Wednesday, August 21, 2013 7:21 PM To: [email protected] Subject: [mssms] Report Subscription Hi All, I have a report subscription (CM12SP1, SQL Server 2012, on Windows Server 2012) of a custom report I made. It's supposed to give the past 14 days of virus infections of when it's run. However, it seems to be showing the past 14 days of when the subscription was created. If I run the report on its own, manually, I get the correct results. Otherwise, I seem to get the results as if I ran it the day the subscription was created (like it's cached the report or the date). It's the "Infected Computers" but with a modified StartDate/EndDate. StartDate and EndDate are a query: select DATEADD(day,datediff(day,0,GetDate())- 14,0) as StartDate, DATEADD(day,datediff(day,0,GetDate()),0) as EndDate Any ideas? My security guy would really like an up-to-date report, not the same old report in his inbox every day :) Gary
