We use Audit Collection Services.

I would like to schedule some of the Audit reports to run every 7 days and email to a sharepoint document library.

Everything works as expected, however I am not sure how to get the parameters set properly.

I see that when setting up the subscriotion, the paramaters only gives you the "Specific" dates to run.

Is there a way to run the report every 7 days using the parameters of the last 7 days since the report last ran?

For Instance.  If I set the report to run on 10-8-2013 and the parameters are for data from 10-01 through 10-07.  I would like the next scheduled report to run as scheduled on 10-16, with only the data from 10-08 through 10-15.

If I have the report scheduled to run every 7 days, how does it know to change my parameters, when I only want the most recent "Last 7 day period"?

I get the impression that it will basically run the same report (date range) every 7 days.

Yes, I do have an Enterprise Edition of SQL on the SCOM 2012 environment.

No I'm not a DBA or report designer.

I hope this makes sense.

• Edited by JCimarex 13 hours 11 minutes ago

when you schedule your report, the From and To parameter should be as

From : today - 7 days

To : today

Roger