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. Right-click the Auditor for Exchange node and select Report Configuration.

2. 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.

3. Enter the Web Service and Report Manager URLs, and then click Connect.

4. Click OK when a successful connection is made. Now the version string is displayed.

5. The Folder box displays the default path for the reports on the server. Click the Browse button to change the location, if needed.
6. Click Deploy to upload the reports.

7. Click OK in the Success dialog box.

Note: You can change the reporting configuration after the reports are deployed by selecting the Report Configuration menu.

View Reports

1. Open the Cygna Auditor for Exchange Viewer.

2. Click Reports on the Home tab.

3. The default browser will open and show the Report Manager URL. Click a report.

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

4. If prompted, set the report parameters and click View Report.

5. The report loads.

Built-In Reports

The following Auditor for Exchange reports are available:

Report Name	Report Description
Address List – Address List Changes – Detailed	View a detailed list of all address list changes.
Address List – Address List Changes – Summary	View general address list changes.
Email Address Policy Report – All Changes	View all changes to e-mail address policies.
Email Address Policy Report – Policies Added or Removed	View e-mail address policies that have been added or removed.
General – Exchange Activity by Mailbox	View general activities performed on Exchange mailboxes by user.
General – Monitored Mailboxes	View all mailboxes for which some activity has been reported.
General – Most Active Mailboxes	View the top mailboxes for which activity has been recorded.
Mailbox Report – All Mailbox Delegations	View reports on the Send As and Full Access permissions.
Mailbox Report – Mailbox Creation and Deletion	View mailboxes that have been created and deleted.
Mailbox Report – Mailbox Quota Changes	View quota changes for individual mailboxes and Exchange servers.
Mailbox Report – Non-owner Access	View mailboxes that have been accessed by accounts other than the owner.
Message Store Report – All Changes	View all changes to the Exchange database.
Message Store Report – Creations and Deletions	View message stores that have been created and deleted.
Server Activity Report – All Changes	View all recorded activity on the selected Exchange servers.
Server Activity Report – Protocol Changes	View all changes to POP3 and IMAP4 protocols on the selected Exchange servers.
Server Activity Report – Security Group – Creations and Deletions	View all Exchange permission changes to the Exchange Administrators list and Role Groups.
Server Activity Report – Storage Group Changes	View changes for all storage groups and their related properties.

Manage Reports in SSRS

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

1. To manage reports, move the cursor over the title of the report and click the arrow.

2. Select a menu item.

Use Report Features

Run a Report Immediately

In any report, you can change the parameters at the top to filter your view. Click View Report after changing parameters to refresh the data.

To hide the parameters area, click the small gray arrow below the pane.

Reporting Toolbar

Between the parameter area and the report data, you will see a toolbar.

Toolbar commands

COMMAND	DESCRIPTION
	Move to the first page or the last page (outer arrows) or ahead or back one page (inner arrows). You can also type a page number in the text box to view.
	Change the zoom level of the report.
	Type a search term (here we have used ALTER) and click Find to view the first instance. Click Next to view the next instance.
	Export report data into a variety of formats, including PDF, Excel, and Word.
	Refresh the report.
	Print the report.
	Export this report to a data feed.

Sort Table Data

To sort table data, click the arrows in the appropriate column header.

Set Report Parameters

A best practice approach is to narrowly scope the report. Otherwise, a significant amount of data can be generated. This may exceed the timeout configuration for SSRS. This may exceed the query timeout configured for the report (default: 30 seconds).

1. Open the Auditor for Exchange reports URL. For more information, please see View Reports.

2. Click the options arrow for any report and click Manage.

3. Click the Processing Options category. Modify the options in the Report Timeout section as desired.

Note: Options on the left navigation menu may vary depending on the version of SQL Server Reporting Services installed.

 
4. Click Apply.