Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This view allows you to generate audit reports using the built-in Microsoft SQL Server Reporting Services Report Viewer (Report Viewer). Each report lets you view and track audited events stored in your event databases and archive files. Use these reports to confirm regulatory compliance, enforce security policies, and capture activity history.

Available actions

Generate a report now

Use the Audit Reports tree to navigate to the appropriate report, and then specify your criteria in the report view.

...

In the Reporting Services pane, click View Deployed Reports. Opens the Report Manager on the Reporting Services server, allowing you to see which SQL CM reports you have deployed.

Available reports

Alert Reports

These reports list alert details, such as target object, affected SQL Server instance, the event, and time of the alert. Use these reports to audit Event and Status Alerts triggered over a specified time period.

...

    • Login Creation History
    • Login Deletion History
    • Server Login Activity Summary
    • User Activity History

 

SQL Compliance Manager audits all activity on your server. Learn more > >