You can view audit data from the Management Console and Reports.
- View the Activity Summary. Select a SQL Server instance in the Explore Activity tree. The Activity Summary appears on the Summary tab.
- View recent audit events. Select a SQL Server instance in the Explore Activity tree. Recent audit events appear on the Summary tab.
- View audited events before archiving. Select a SQL Server instance in the Explore Activity tree, and then select the Audit Events tab.
- View archived events. Select a monitored SQL Server instance or database from the Explore Activity tree and then select the Archived Events tab. For more information, see Attach existing archives.
- Report on events. To report on events, click Reports in the console tree pane, and then select the report you want to view. For more information, see Report on Audit Data.
SQL Compliance Manager monitor, audit and alert on SQL user activity and data changes. |  |  |  |  |  |  | 
|
