You’ll notice that when you create a subscription for a report that requires date parameters in the Configuration Manager console that you can only select a static date range.
Typically when you are setting up a subscription, you want the report to run for a date range relative to when it is being delivered. For example, when you setup a daily subscription, you would want to use a date range since yesterday as that’d be the last time that you received the report.
You can easily do this using the report's default dates. Depending on your needs, you can also modify the default dates for existing or custom reports.
In this example, I’m using the built in Endpoint Protection “Infected Computers” report.
Note the Use Default options for the start and end date:
The default start and end dates for this report is currently set to a week of data. You can setup your report with the above options, and you’ll get a current weeks worth of data every time the report is delivered.
Let’s say that you want to change this to deliver one days worth of data. To do so, you’d need to edit the existing report with Report Builder. For more information about using Report Builder, you can go here.
Note: Any time you are making modifications to reports, you should keep the original and save the custom one with a new name.
To edit an existing report, you simply right click the report in the ConfigMgr console and select Edit.
This will open the report in report builder.
To modify the default values for the “Infected Computers” report to daily, you’d do the following:
To Save the report:
Now when you go back to the report to setup a subscription, you’ll see that the default start date is now yesterday rather than last week:
Great work Ryan, this helped a lot!