SRM for Exchange - Reports

Managing storage resources is a critical job for any organization, which can be challenging because these resources are distributed across the network. SRM Exchange reports provide a sleek, versatile, and easy-to-use reporting framework that enables you to compare mailbox sizes, display messages that have been archived and display generic information on your Exchange Servers. Customized reporting is available through the selection of filter criteria e.g., individual columns, specific clients, specific client computer groups, report options, and SQL Queries.

Configuration

Reports are generated from the data collected in a data collection job. The data is then stored on the SRM Server. Schedule your first reports to run after your first data collection jobs have completed. Note that data collection and Report Generation jobs are scheduled independently, at different times and intervals. Thus, you can, for example, collect data nightly, hourly, or on-demand, but generate reports only once per week if desired.

The SRM for Exchange Database iDataAgent collects data only for the default subclient. Data is not collected for any other subclients on the SRM for Exchange Database iDataAgent. Therefore, only data for the default subclient appears in reports.

Option

Description

Enable SRM for all backups

SRM can be enabled from the Agent levels for the iDataAgent. When Enable SRM is selected at the Agent level, SRM options get enabled for all subclients.

From the CommCell Browser, right-click the iDataAgent for which you want to enable SRM feature and select Properties.
Enable SRM must be selected from the General tab.
A Discovery and Analysis Data Collection job is automatically set when you enable SRM.
Then confirm your selection by clicking OK.

Run a Backup

A full backup contains all the data that comprises a subclient's contents. If a client computer has multiple agents installed, then the subclients of each agent require a full backup in order to secure all of the data on that client.

To perform a full backup, right-click the subclient, and click Backup in the CommCell Browser.
One of the following options must be selected from the Backup Options dialog box:

Backup Type:
Select Full.
Backup Schedule:
Select Immediate if you want to run the backup now.
Granular Recovery:
Select Enable Granular Recovery if you intend to restore individual files and folders from a disk or volume-level backup.

Then confirm your changes by clicking OK.

You can track the progress of the backup job from the Job Controller window. When the backup has completed, the Job Controller displays Completed.

After performing a first full backup you may select any other backup type for performing Data Collection operations.

Generate SRM Reports

The sections below discuss running, scheduling, and saving a report.

Running a Report

You can choose to run a report so that you view it immediately. Alternatively, to view it at a later point in time you can schedule it or save it as a template to a file. When running a report, you can choose an out-of the box template or generate a more customized report by picking and choosing individual columns from a category.

To run a SRM Report immediately:

1.	From the CommCell Browser, click Reports, and then click SRM Report Manager.
2.	Expand the applicable tree to view your agent. Then click a template to display the Options window.
3.	Click the Client Selection tab and select the client computers or client computer group. This is a required step.
4.	Click Column Selection tab. For an out-of-the-box template, the columns are displayed here. To change the columns, select a category and click Add or Remove to move the columns between the Available and Selected boxes. Clicking Remove All will remove all previously selected filters for the reports.
5.	Click Run to generate the report immediately and view the results.

Scheduling a Report

Scheduling allows you to run a report on a user-defined schedule, send it in a different language or format, and configure notifications for specified recipients when the report has run. Reports can be scheduled so that they follow a backup schedule in order to guarantee up-to-date reporting. Scheduling a report involves these tasks:

Specify a daily, weekly, monthly, yearly, or even one time basis schedule. When scheduling, patterns can be applied to the report so it runs on a specific time, repeated every so many days, or run for a particular number of times.
Scheduled reports support different languages and formats. Default language is English and default output is HTML. You can even save the report to local drive or a network share.
When scheduled reports are run, notifications can be sent in the form of an email or page, SNMP trap, RSS feed, or Event Viewer message to inform email recipients, computers, or a script that a report has run and is now available.

To schedule a SRM Report:

1.	From the CommCell Browser, click Reports, and then click SRM Report Manager.
2.	Expand the applicable tree to view your agent. Then click a template to display the Options window.
3.	Click the Client Selection tab and select the client computers or client computer group. This is a required step.
4.	Click Column Selection tab. For an out-of-the-box template, the columns are displayed here. To change the columns, select a category and click Add or Remove to move the columns between the Available and Selected boxes. Clicking Remove All will remove all previously selected filters for the reports.
5.	Click Schedule to generate and schedule the report on a daily, weekly, monthly, yearly, or even one time basis. Optionally, click Report Options to repeat sending the report every so many days, or run it for a particular number of times. Click Next.
6.	Select the report output options, such as: Format - select MHTML, EXCEL, or PDF. Specify a path in Destination Path if you want to save the report to a local drive or network share. Click Next.
7.	Configure the notifications for the scheduled report, such as: Select the E-Mail/Pager tab and click Select [E-Mail/Pager] for notification. Click either Use default message or add more tokens by selecting Add Token. Select the SNMP tab and click Select [SNMP] for notification. Click either Use default message or add more tokens by selecting Add Token. The SNMP Enabler software must be installed on the CommServe. See SNMP Enablers for more information. Select the Event Viewer tab and click Select [Event Viewer] for notification. Click either Use default message or add more tokens by selecting Add Token. Select the Run Command tab and click Select [Run Command] for notification. Click either Run on CommCell or Run on Client. Specify a path in Command Script Location and optionally specify arguments for the script in Arguments. Click Run Data Archiver tab to write files and directories of the report to a text file. Click RSS Feeds tab and click Select [RSS Feeds] for notification. Click either Use default message or add more tokens by selecting Add Token. Specify a feed location in Select/Enter the FeedLocation field. Click Next. Refer to the Actions documentation for more comprehensive information.
8.	In this dialog, select the recipients for the scheduled report. Use the Add> or <Remove buttons to specify CommCell users as the notification recipients. Or, enter one or more email addresses in the Email to Recipients field. Separate multiple addresses with commas. Click Next.
9.	Review the summary and if satisfied, click Finish.

Saving a Report

Saving a report allows you to save the filter criteria and schedule information, including notifications, to a template so it can be used to generate a report at a later date. All report templates are saved under My Reports.

To save a SRM Report to a template:

1.	Create a report and optionally specify scheduling criteria as explained in Scheduling a Report. Advanced criteria such as Filters will also be saved in the report template.
2.	In the right-hand corner, click Save As... and enter a name for the report and click OK.
3.	The report template is saved under My Reports.

Send a Notification when a SRM Report Has Run

Configuring notifications is a step when scheduling a report. For example, when scheduled reports are run, an email notification can be sent to inform the recipient that a report has run and is now available. The recipient can be either a CommCell user, a CommCell user group, a domain or external user (e.g., yahoo, gmail, etc.), or a pager address. For a comprehensive description of all notification types, refer to Actions.

To send an Email notification when a scheduled report has run:

From the CommCell Browser, click Reports, and then click SRM Report Manager.

Click Applications or Enterprise. Then click a template to display the Filters window.

Configure the report by specifying clients and columns, report options, and optionally, ad hoc queries. Refer to Options, Report Options, and Filters respectively.

Click Schedule to generate and schedule the report on a daily, weekly, monthly, yearly, or even one time basis.

Optionally, click Options to repeat sending the report every so many days, or run it for a particular number of times.

Click Next.

In this dialog, select the report output options, such as:

Format - select HTML, EXCEL, or PDF.
In Locale, select a report language. See Languages - Support for the list of supported languages.
Specify a path in Destination Path if you want to save the report to a local drive or network share.

TIFF is no longer a supported output format. SRM supports saving Reports in these formats: HTML, EXCEL, and PDF.

Click Next.

In this dialog, configure the E-Mail/Pager notification for the scheduled report as follows:

Click Select [E-Mail/Pager] for notification.
Either accept default format or add more tokens by selecting a token from the pulldown menu and clicking Add Token. The tokens are explained in Alert Tokens. Click Use default message to revert back to original default format.

Click Next.

In the User(s) and User Group(s) Selection dialog, specify the recipients to whom the notification will be sent as follows:

To add or remove CommCell users or a CommCell user group, select a user in the Available or Selected boxes and click Add> or <Remove.
To specify a domain or external user (e.g., yahoo, gmail, etc.) or a pager address, enter the email address in Email to Recipients field. Separate multiple addresses with a comma.

Review the summary and if satisfied, click Finish.

Getting Started with Exchange Server Reports

The following illustrates a few possibilities of how Exchange Server reports can be generated and used. For more information that explains the reports comprehensively and how to generate reports using all possible features, refer to Advanced page.

Mailbox Distribution by Size

Use this report to compare mailbox sizes of a store so that if a mailbox exceeds a normal capacity for your enterprise, quotas could be increased on the Exchange Server to allocate the additional space that is required.

To display mailbox sizes of a store:

1.	From the CommCell Browser, click Reports, and then click SRM Report Manager.
2.	Click Applications and click Exchange.
3.	Click the Mail Distribution by Size template and select the client computers in the Client Selection tab.
4.	Click Run. Graphs showing mailbox count and mailbox total size are displayed as well as a list of mailboxes by computer, exchange server, storage group, mailbox store, and group.

Message Distribution by Age

Use this report to display messages that have been archived and how much media space was required for each archive job run.

To view messages that have been archived:

1.	From the CommCell Browser, click Reports, and then click SRM Report Manager.
2.	Click Applications and click Exchange.
3.	Click the Mail Distribution by Age template and select the client computers in the Client Selection tab.
4.	Click Run. Graphs showing message age distribution by total count and total sizeare displayed as well as a list of mailboxes by computer, exchange server, storage group, mailbox store, mailbox, group, count, size, and type.

Mailbox Stores

Use this report to view the size of the mailboxes per store to aid in restructuring the mailboxes equally across stores. For example, if one store is over-weighted with mailboxes, mailboxes can be redistributed to a store with fewer mailboxes.

To view mailboxes across stores:

1.	From the CommCell Browser, click Reports, and then click SRM Report Manager.
2.	Click Applications and click Exchange.
3.	Click the Mailbox Stores template and select the client computers in the Client Selection tab.
4.	Click Run.

Server Information

Use this report to display generic information on your Exchange Servers and ensure that they are up-to-date.

To view Exchange Server information:

1.	From the CommCell Browser, click Reports, and then click SRM Report Manager.
2.	Click Applications and click Exchange.
3.	Click the Server Information template and select the client computers in the Client Selection tab.
4.	Click Run. A list of Exchange Servers is displayed along with its version number, administration group to which it belongs, and if Message Tracking is enabled or not.

DAG Clients information

Use this report to display the information on DAG clients and ensure that they are up-to-date.

1.	From the CommCell Browser, click Reports, and then click SRM Report Manager.
2.	Click Applications and click Exchange.
3.	Click the Exchange DAG Information template and select the client computers in the Client Selection tab.
4.	Select DAG Clients. Click Run. A list of DAG clients' Information is displayed along with their version numbers, administration group to which they belong, Exchange Server Name, Primary Active Manager and Operation servers.