Page History

The Daily Audit Activity Statistics IDERA SQL Compliance Manager Audit Reports view contains a simple interface that allows you to generate audit reports. Each report is based on a template file that is stored in the Reports folder in the SQLcompliance installation directory. When you generate a report, you are able to determine what is displayed by selecting from the options on each individual report. This allows you to generate reports tailored to your needs.

For additional information about SQL compliance Manager reporting, see Report on Audit Data.

Image Added

Available reports include:

• Application Activity. The Application Activity 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.
• DML

...

• Activity (Before-After). The DML Activity (Before-After) report lists DML events for which before and after data is available. Use this report to audit UPDATE, INSERT, and DELETE activity on critical or sensitive databases.

User Audit Reports

• Login Creation History. The Login Creation History report lists a history of login creation activities performed on a specific SQL Server instance

...

• . Use this report to audit user behavior and login management.
• Login Deletion History. The Login Deletion History report lists a history of login

...

• deletion activities performed on a specific SQL Server instance. Use this report to audit user behavior and login management.

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

Security Audit Reports

• Object Activity. The Object Activity report lists activities performed on a specific SQL Server instance. Use this report to audit object behavior and settings.
• Permission Denied Activity. The Permission Denied Activity report lists

...

• unauthorized attempts to execute activities. Use

...

• this report to audit your SQL Server security settings and identify misconduct.
• Change History (by object)
• Change History (by user)
• Permission Denied Activity
User Login History
• User Activity History. The User Activity History report lists activities performed by user account. Use this report to audit your user account settings and identify misconduct.

...