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.
Generate a report
To report on audit data:
- In the console tree pane, click Reports.
- In the view pane, select the report you want to generate.
- Specify the appropriate parameters for the selected report, and then click View Report.
You can find all the available reports in the following categories:
Exporting a report
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:
- Excel
- Word