IDERA SQL Secure includes built-in reports specially designed to generate commonly requested audit reports using the SQL Server permission data collected in your snapshots.
SQL Secure built-in reports allow you to quickly and easily meet the demands of on-the-spot audits, routine audits, and long-term event trending. Each report provides detailed information about events in your SQL Server environment.
Using the Console to generate reports against large audit data sets can result in degraded performance. For example, when the selected snapshot is large (contains thousands of objects and permissions), the report performance may be impacted. If you experience degraded performance, try increasing the Console timeout value and, if the performance issues continue, run the report with Microsoft Reporting Services instead. |
To report on audit data:
You can find all the available reports in the following categories:
To export a report, click the Export icon located on the top menu above the report, and choose the preferred option.
You can export a report in the following formats:
|