Page History
This 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.
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 Deploy Reports. Starts the Reports Installer, allowing you to deploy individual IDERA SQL Compliance Manager reports to your existing Reporting Services server and customize the report.
...
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 Compliance Manager 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.
- Alert Activity - Data
- Alert Activity - Events
- Alert Activity - Status
...
- Application Activity
- Application Activity Statistics
Configuration Check Report
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
...
The Database Schema Change History report lists schema changes applied to audited databases. Use these reports to audit data definition language (DDL) statements, such as dropped tables, executed against one or more databases on a SQL Server instance.
Host Audit ReportsReport
The Host Activity report lists all host computers from which specific logins executed an action. Use this report to audit user behavior from multiple client computers, identifying the host computer from which an activity request originated.
Privileged / Trusted Users Report
The Privileged User/Trusted User report lists trusted and privileged users of a specified server instance or database. Use this report to view the list of trusted/privileged users on specific servers and databases.
Policy Audit Reports
These reports list changes and updates applied to the SQLcompliance SQL Compliance Manager Agent deployed on a specific SQL Server, and any integrity violations in your audit data. Use these reports to diagnose audit data integrity issues and track agent configuration changes as well as agent activities, such as SQLcompliance SQL Compliance Manager Agent service restarts.
- 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.
- Change History (by object)
- Change History (by user)
- Permission Denied Activity
- User Login History
- Table/Data Access by Row count
Server Activity Report Card Report
The Server Activity Report Card report allows you to review the activity status and recent audit event history on your SQL Server instance. Use this report to display a particular server´s activity status.
User Audit Reports
These reports list user activities performed on a specific SQL Server instance, and provide a history of login creations and deletions. Use these reports to audit user behavior and login management.
- Login Creation History
- Login Deletion History
- Server Login Activity Summary
- User Activity History
Scroll pdf ignore | ||||||
---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Compliance Manager audits all activity on your server. Learn more > >
...