The Daily Audit Activity Statistics Report lists the amount of activity that occurred on the SQL Server instance or designated database, on an hourly basis, for the dates specified. Use this report to audit overall activity levels on your SQL Server instances and databases.
A filter can include a list of wildcards, separated by commas, where a wildcard is a string, which may contain asterisks. The following parameters are specific to the selected report and enable you to filter the data to include in the report.
Available actions
Server Instance
Allows you to select a registered instance on which you want to report. Select ALL to report on all instances.
Databases
Allows you to select or type the name of one or more databases on which you want to report.
Start Date
Allows you to select the start date for the range from which you want to report.
End Date
Allows you to select the end date for the range from which you want to report.
Start Time - Hour
Allows you to select the exact starting hour of the day for the range from which you want to report.
Start Time - Min
Allows you to select the exact starting minute of the day for the range from which you want to report.
Start Time - AM/PM
Select between AM or PM from the drop down list to configure the Start Time for Each Day range from which you want to report.
End Time - Hour
Allows you to select the exact ending hour of the day for the range from which you want to report.
End Time - Min
Allows you to select the exact ending minute of the day for the range from which you want to report.
End Time - AM/PM
Select between AM or PM from the drop down list to configure the End Time for Each Day range from which you want to report.
Run Report
Click this button to Run the report.
Default columns
Chart and details
Presents the daily audit activity statistics data in a graph along with details.
