Basic | Advanced | Filters | Summaries | Best Practices |
SRM reporting provides a sleek, versatile, and easy-to-use reporting framework that enables you to easily and effectively choose, view, and analyze vital data. Enterprise and application-based reports can be rapidly generated with out-of-the-box templates or customized with filter criteria. Reports can be run immediately or scheduled to run daily, weekly, monthly, etc.
In essence, SRM Exchange reports provide these features:
The following sections describe the SRM Exchange reporting features in more detail.
The following features are provided by SRM Reports.
Out-of-the box templates provide pre-selected columns and can be run immediately after selecting clients or client computer groups. To generate a customized report, you can start with a template and then alter the pre-selected columns by adding or removing the columns. Note that when selecting clients, SRM data collection must be enabled and a full backup needs to have run for the Agent in order to have up-to-date information presented in the report.
Pay particular attention when specifying filter criteria. Selecting criteria judiciously will aid in generating a useful report. Otherwise, the report may be too cumbersome and cluttered. |
The report options control how data is presented in the report. Either accept the defaults or modify the options as described below.
For the columns selected, Filters can also be applied to further refine the data in the report.
Selecting the Get Query tab will display the SQL query in long notation that will be used to get the data and generate the report. The query that is displayed is Read-only and can be used in a third-party SQL application, such as SQL Server Management Studio.
Configuring notifications is a step when scheduling a report. When scheduled reports are run, notifications can be sent in the form of an email or page, SNMP trap, RSS feed, Event Viewer message to inform email recipients, computers, or a script that a report has run and is now available. The possible notifications are explained in the sections below.
A notification can be sent to email or pager recipients when a scheduled report has run. 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.
A notification can be e-mailed or sent to a pager to a selected list of recipients when a scheduled report has run. The recipients can be either a CommCell user, a CommCell user group, a domain or external user (e.g., yahoo, gmail, etc.), or a pager address.1. | From the CommCell Browser, click Reports, and then click SRM Report Manager. | |
2. | Expand the applicable tree to view your agent. Then select your agent and click a template to display the Options window. | |
3. | Configure the report by specifying clients and columns, report options, and optionally, ad hoc queries. | |
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. |
In this dialog, select the report output options, such as:
Click Next. |
|
7. |
In this dialog, configure the E-Mail/Pager notification for the scheduled report
as follows:
Click Next. |
|
8. |
In the User(s) and User Group(s) Selection dialog, specify the
recipients to whom the notification will be sent as follows:
|
|
9. | Review the summary and if satisfied, click Finish. |
A notification can be sent by a CommServe, using the SNMP protocol, to other computers in the form of SNMP traps when a scheduled report has run. This notification type requires that the SNMP Enabler software must be installed on the CommServe computer. See SNMP Enablers for more information.
1. | From the CommCell Browser, click Reports, and then click SRM Report Manager. | |
2. | Expand the applicable tree to view your agent. Then select your agent and click a template to display the Options window. | |
3. | Configure the report by specifying clients and columns, report options, and optionally, ad hoc queries. | |
4. |
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. |
|
5. |
In this dialog, select the report output options, such as:
Click Next. |
|
6. |
Click the SNMP tab and configure this notification type as follows:
Click Next. |
|
7. | Review the summary and if satisfied, click Finish. |
A message can be sent to the Event Viewer on the CommServe when a report is run or scheduled.
1. | From the CommCell Browser, click Reports, and then click SRM Report Manager. | |
2. | Expand the applicable tree to view your agent. Then select your agent and click a template to display the Options window. | |
3. | Configure the report by specifying clients and columns, report options, and optionally, ad hoc queries. | |
4. |
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. |
|
5. |
In this dialog, select the report output options, such as:
Click Next. |
|
6. |
Click the Event Viewer tab and configure this notification type as follows:
Click Next. |
|
7. | Review the summary and if satisfied, click Finish. |
A notification can be sent to a script when a scheduled report has run. Once receiving the notification, the script can be specified to run on the CommCell or a client computer. Arguments can be specified for the script as well. You can also select an option to read and archive a list of files and directories of a report if a supported Archiver Agent is installed on the client computer and an On Demand Archive Set is configured with SRM enabled.
A notification can be sent to run a Data Archiver operation when a scheduled report has run. You can select an option to read and archive a list of files and directories of a report if a supported Archiver Agent is installed on the client computer and an On Demand Archive Set is configured with SRM enabled. For the Data Archiver schedule to run successfully, archive rights on the client computer are required.
A notification can be sent in a Really Simple Syndication (RSS) feed when a scheduled report has run. The RSS feed can be automatically integrated with your Web Browser.
1. | From the CommCell Browser, click Reports, and then click SRM Report Manager. | |
2. | Expand the applicable tree to view your agent. Then select your agent and click a template to display the Options window. | |
3. | Configure the report by specifying clients and columns, report options, and optionally, ad hoc queries. | |
4. |
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. |
|
5. |
In this dialog, select the report output options, such as:
Click Next. |
|
6. |
Click the RSS Feeds tab and configure this notification type as follows:
Click Next. |
|
7. | Review the summary and if satisfied, click Finish. |
Forecasting is prediction of data usage in future, based on the usage pattern in the past. Since Prediction allows visualizing data usage in future, it helps make business decisions accordingly. Prediction is available on history reports and it can be done based on Daily/weekly/Monthly data. In the graphs, prediction lines are shown as thin lines while the actual usage is shown as thick lines.
When viewing a report in the CommCell Console, you can copy any chart to the clipboard in .bmp format by right-clicking the chart and selecting Copy Chart. This allows you to easily copy a chart into other applications. Note that the Copy Charts function is not compatible with Microsoft WordPad.
The following table lists the available SRM Exchange Agent categories and columns that can be selected to configure a customized report.
Category/Column | Description | SRM Exchange Agent | |
Discovery Job | Discovery and Analysis Job | ||
Client Properties | Displays aspects of the client computer on which the SRM Exchange Server Agent is installed. | ||
Hostname | |||
Memory | |||
Operating System | |||
OS Vendor | |||
OS Version | |||
Processors | |||
Service Pack | |||
SP Version | |||
Time Zone | |||
DAG | Displays information of mailbox servers as part of a database availability group (DAG), which provides automatic recovery at the individual mailbox database level instead of at the server level. | ||
Admin Display Name | |||
Alternate Witness Server | |||
Alternate Witness Directory | |||
Database Availability Group IPv4 Addresses | |||
Datacenter Activation Mode | |||
Distinguished Name | |||
Exchange Version | |||
GUID | |||
Is Valid | |||
Name | |||
Network Compression | |||
Network Encryption | |||
Network Names | |||
Object Category | Exchange -2010 do not support Public Folder Object Category. | ||
Object Class | |||
Operational Servers | |||
Organization Id | |||
Originating Server | |||
Primary Active Manager | |||
Replication Port | |||
Runspace Id | |||
Servers | |||
Started Mailbox Servers | |||
Stopped Mailbox Servers | |||
Third Party Replication | |||
When Changed | |||
When Created | |||
Witness Directory | |||
Witness Server | |||
Exchange Entities | Displays overall aspects per each computer selected (e.g., computer name, host group, etc.). | ||
Administration Group | |||
Client Computer Group | |||
Collection Status | |||
Collection Time | |||
Computer | |||
Exchange Server Name | |||
Folder Tree | |||
Mailbox Store | |||
Public Folder | |||
Public Store | |||
Storage Group | |||
Mailbox Distribution by Message Count | Displays a list of mailboxes per message counts (e.g., computer name, host group). | ||
Group | |||
Item Count | |||
Total Size | |||
Type | |||
Mailbox Distribution by Size | Displays sizes of mailboxes (total size, type, item count, and group). | ||
Group | |||
Item Count | |||
Total Size | |||
Type | |||
Mailbox Store Details | Summarizes aspects of mailbox stores (i.e. database that contains
the mailboxes) and compares the relative sizes of the mailbox stores in
your enterprise.
|
||
Copies | |||
Copy Servers | |||
Database | |||
Healthy Copy Servers | |||
Mailbox | |||
Mailbox Archived Item Count | |||
Mailbox Archived Space Saved | |||
Mailbox Item Count | |||
Mailbox Size | |||
Mailbox Store Size | |||
Mailboxes Total Size | |||
Mounted Server | |||
Prohibit Send Quota | |||
Prohibit Send Receive Quota | |||
Streaming Database | |||
Total Mailboxes Archived Space Saved | |||
Warning Quota | |||
Mailbox Store History | Displays store size and mount status from past data collections of each mailbox store over time. Used for trending purposes. | ||
As Of | |||
Mounted | |||
Size | |||
Message Distribution by Age | Displays graphs showing message age distribution by total count and total size as well as a list of mailboxes by computer, exchange server, storage group, mailbox store, mailbox, group, count, size, and type. | ||
Group | |||
Item Count | |||
Total Size | |||
Type | |||
Message Distribution by Attached File Type | Displays graphs showing message attached file type distribution by total size and by file count. | ||
Group | |||
Item Count | |||
Total Size | |||
Type | |||
Physical Devices | Displays graphs showing partition count, block counts, unallocated space, cost category, and allocated space. | ||
Allocated Space | |||
Block Counts | |||
Block Size | |||
Capacity | |||
Computer | |||
Cost Category | |||
Disk Name | |||
Interface | |||
Manufacturer | |||
Partition Count | |||
Serial Number | |||
Public Folder Distribution by Size | Displays graphs showing public folder total size and public count distribution by size. | ||
Group | |||
Item Count | |||
Type | |||
Total Size | |||
Public Folder Object Distribution by Modification Age | Displays graphs showing public folder object modification age distribution by total size and by object. | ||
Group | |||
Item Count | |||
Total Size | |||
Type | |||
Public Folder Object Distribution by Type | Displays graphs showing public folder object space usage distribution by type and count distribution by type. | ||
Group | |||
Item Count | |||
Total Size | |||
Type | |||
Public Store Details | Summarizes aspects of public stores and compares the relative sizes and other characteristics of the public stores present in your enterprise. | ||
Database | |||
Maximum Item Size | |||
Mounted | |||
Prohibit Post Quota | |||
Public Folder Item Count | |||
Public Folder Size | |||
Public Folders Total Size | |||
Public Store Size | |||
Server Name | |||
Streaming Database | |||
Warning Quota | |||
Public Store History | Displays store size and mount status from past data collections of each public store over time. Used for trending purposes. | ||
As Of | |||
Mounted | |||
Size | |||
Server Details | Summarizes aspects of the Exchange server. | ||
Back End Type | |||
Circular Logging Enabled | |||
Client Access Type | |||
Edge Transport Type | |||
Front End Type | |||
Hub Transport Type | |||
Log File | |||
Mailbox and Public Stores Total Size | |||
Mailbox Stores | |||
Mailbox Stores Total Size | |||
Mailbox Type | |||
Message Tracking Enabled | |||
Public Stores | |||
Public Stores Total Size | |||
Service Pack | |||
Storage Group Size | |||
Storage Group Volume | |||
Subject Logging Enabled | |||
System File | |||
Unified Messaging Type | |||
Version | |||
Zero Database Enabled | |||
Storage Group History | Displays storage group size (including the log files and system size) from past data collections and growth tracking of each storage Group over time. Used for trending purposes. | ||
As Of | |||
Size | |||
Subclient Details | Displays total size and count of mailboxes and public folders on each Exchange Server, per subclient. | ||
Mailboxes | |||
Public Folders | |||
Subclient | |||
Total Mailbox Size | |||
Total Public Folder Size | |||
Total Size |