Versions Compared

Key

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

The Audit reports 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.

Image Added

Available actions

Generate a report now

...

    • Application Activity
    • Application Activity Statistics

Configuration Check Reports

The configuration check report lists all the configurations selected on a Server or Database. Use these reports to reconcile the differences in regards to the configurations across different servers and databases.

Database Object Audit Reports

These reports list backup, restore, DBCC, DML, and database object activities on specific databases. Use these reports to audit mass data movement or database object activity, such as SELECT or UPDATE, across multiple databases.

...

    • Agent History
    • Alert Rules
    • Audit Control Changes
    • Integrity Check

Regulation Audit Reports

These reports list all the regulations and their individual guidelines applied to your servers and databases. Use the Regulation Guideline report to audit the regulatory guidelines applied to your SQL Server instance, or use the Regulation Compliance Check report to ensure that your servers and databases continue to be in compliance with the selected regulatory guidelines.

    • Regulation Guideline Report
    • Regulation Compliance Check Report

Security Audit Reports

These reports list permission changes by object type as well as unauthorized attempts to execute activities. Use these reports to audit your SQL Server security settings and identify misconduct.

...