Work with Reports

Reporting is provided through Microsoft SQL Server Reporting Services (SSRS). SSRS needs to be implemented and configured before you can deploy reports.

For more information, please see Microsoft’s SSRS documentation for installation and configuration procedures.

Before Deploying Reports

Before you deploy reports to SSRS, you need to know the Web Service URL and the Report Manager URL. You configure the settings when you initially set up SSRS.

Open the SQL Server Reporting Services Configuration Manager, and make note of the URLs.

Web Service URL

Report Manager URL

Deploy Reports

  1. Select the Cygna Auditor for SQL Server node.
  2. Click the Click here to configure reports link in the right pane.
  1. The Reporting Services Configuration dialog box opens.
    • If reports are deployed, the fields will be completed.
    • If reports are not deployed, the fields will be empty.
  1. Enter the Web Service and Report Manager URLs, and then click Connect.
  1. Click OK when a successful connection is made. Now the version string is displayed.
  1. The Folder box displays the default path for the reports on the server. Click Browse to change the path, if necessary.
  1. Click Deploy to upload the reports.
  1. Click OK in the Success dialog box.

Note: You can change the reporting configuration after the reports are deployed by clicking Click here to configure reports in the Auditor for SQL Server dashboard.

View Reports

  1. Double-click an audit view to open the SQL Server Viewer.
  1. Click Open Reports on the Home tab.
  1. The default browser opens and shows the Report Manager URL. Click a report.

Note: This is a static URL for all Auditor for SQL reports. Bookmark it for quick reference in the future.

  1. If prompted, set the report parameters and click View Report.
  1. The report loads.

Built-In Reports

The following Auditor for SQL reports are available.

Report Name Report Description
All Audit Events Summary View a summary report of all audit events.
All SQL Server Changes View all SQL server audit activity.
Deleted SQL Server Objects View deleted objects, such as tables, indexes, and procedures.
Events by Database View a summary report of events by SQL server and database.
Events by Database and Type View a summary report of events by SQL server, database, and event type.
Events by Type View a summary report of events by event type.
Failed Login Attempts View failed login attempts.
Function Changes View all creations, deletions, and modifications performed on functions.
Index Changes View all creations, deletions, and modifications performed on indexes.
Login Changes View all creations, deletions, and modifications performed on SQL server logins.
Modified SQL Server Objects View modified objects, such as tables, indexes, and procedures.
Newly Created SQL Server Objects View objects (such as tables, indexes, and procedures) that have been created in the past seven days.
Procedure Changes View all creations, deletions, and modifications performed on functions.
Server Instance Changes View changes to the SQL server global configuration settings. Not available for SQL Server 2005.
Server Role Changes View when members have been added to or removed from a SQL server role.
Server Summary View a summary report of event count by database and by type.
Table Changes View all creations, deletions, and modifications performed on tables.
User Changes View all creations, deletions, and modifications performed on users.
View Changes View all creations, deletions, and modifications performed on views.

Manage Reports

SQL Server Reporting Services features are available for Auditor for SQL reports.

  1. To manage reports, move your mouse over the title of the report and click the arrow.
  1. Choose an option from the menu.