Page History

The Backup and DBCC Activity Report ....... allows users to configure their preferred email and SNMP settings, as well as to groom undesired alerts on your SQL Servers. lists all backup, restore and DBCC activity on specific databases. Use these reports to audit mass data movement or database object activity, such as SELECT or UPDATE, across multiple 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.

...

Allows you to select or type the name of one or more databases on which you want to report.

Login

Allows you type or to select the login from the drop down list of available logins. Select ALL to report on all logins.

Start Date

Allows you to select the start date for the range from which you want to report.   

...

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.

Schema

Allows you to type the name of the schema on which you want to report.

...

Select between True or False from the drop down list menu to show filter the report by SQL Text as part of the report.

Privileged Users Only

Select between True or False from the drop down list to report on Privileged Users only or to report on All User types

...

Click this button to Run the report. 

Default columns

Event

The Event column displays a description of the event captured. 

...

The Time column displays the date and time when the event was captured. 

SQL

The SQL column when set to True, provides the name of the audited SQL Server instance where this event occurredSQL Statement for the captured event.

...