Reporting Services for Exchange 2007 Management Pack

  • Article

Microsoft Exchange Server 2007 will reach end of support on April 11, 2017. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.

 

Applies to: Exchange Server 2007, Exchange Server 2007 SP1, Exchange Server 2007 SP2, Exchange Server 2007 SP3

The Microsoft® Exchange Server 2007 Management Pack provides several reports with which to view service availability, and anti-spam statistics, as well as performance and usage metrics. The reports are present data over time, with easy-to-read graphs, charts, and tables. The reports are useful as an overview of the current Exchange organization, or to do an in-depth examination in specific areas.

Microsoft Operations Manager (MOM) reporting is accomplished by querying the MOM data warehouse for the data that you want, summarizing the data, and then creating an output report of formatted data. Because reporting relies on the data warehouse, you must have the full version of MOM 2005 Service Pack 1 (SP1) deployed.

The Exchange 2007 Management Pack includes predefined reports, and you can create custom reports according to your requirements. In MOM 2005, data is transferred daily from the operational database to the data warehouse database. By default, the data transfer occurs at 1:00 A.M., but the schedule can be changed to accommodate your needs by modifying the Scheduled Task on the SQL server that is hosting the MOM data warehouse. You can also increase the frequency that data is transferred to the data warehouse by configuring the existing schedule task to repeat throughout the data, or by making a copy of the scheduled task and configuring the copy to run at a different time.

The reports in the Exchange 2007 Management Pack offer a richness of reporting and information beyond what was available in earlier versions of Exchange management packs. Additionally, each report has in-depth information about the report itself. Information in the reports includes the following:

  • Description of the purpose and objectives of the report

  • Report parameters

  • Related rules

  • Calculation method (where appropriate)

  • Click through functionality (click fields to see more detailed information)

The following is a list of the reports that are in the Exchange 2007 Management Pack.

  • Service Availability

    • Service Availability Summary

    • Mailbox Service Availability

    • Mailflow Local Service Availability

    • Mailflow Remote Service Availability

    • Outlook Web Access External Service Availability

    • Outlook Web Access Internal Service Availability

    • ActiveSync Internal Availability

    • Unified Messaging Local Voice Service Availability

    • Unified Messaging Local Fax Service Availability

    • Unified Messaging Remote Voice Service Availability

  • Metrics

    • Client Performance

    • Mailbox Count

    • RPC and Database Performance

    • Unified Messaging Call Summary

    • Unified Messaging Message Summary

  • Anti-Spam

    • Attached File Filter

    • Connection Filter

    • Recipient Filter

    • Sender ID

    • Sender Filter

    • Content Filter

    • Protocol Analysis

The topics in this section are intended to help you identify which reports would be useful to run, and to note any considerations in running the individual reports.

Running the Reports

The reports are generated by SQL Reporting Services and can be reached from the MOM 2005 Administrator Console.

Or, on the Start menu, you can open the Reporting Console located in the Microsoft Operations Manager 2005 group.

To access the reports from the MOM 2005 Administrator Console

  1. Open the MOM 2005 Administrator Console.

  2. Click Operations in the left pane, and then click Start Reporting Console.

  3. Click Microsoft Exchange Server.

  4. Click the category of reports that you want to work with. (For example, click Exchange 2007 Anti-Spam.)

  5. Click the report that you want to see (For example, click Connection Filter.) The report will now be generated.

To access the reports from the MOM 2005 Operator Console

  1. Open the MOM 2005 Operator Console.

  2. In the Go menu, click Open Reporting Console.

  3. Follow the same steps from step 3 onwards in the previous procedure.

For any reports, you can specify the time frame that the report should be generated for, as well as which servers should be included.

If you want to report on a specific set of servers, such as a subset of the Exchange 2007 Mailbox servers, you can create a custom Computer Group in the MOM Administrator Console, and then add the server you want to the group. Then, the next time that MOM transfers data from the operational database to the data warehouse, the computer group that you create will display in the list of computer groups.

Configuring Subscriptions

For more information about how to configure subscriptions that will send reports by e-mail, or save them to a file share, see https://go.microsoft.com/fwlink/?linkid=77524.

Configure an Execution Snapshot Schedule

For any reports that you feel are taking too long to generate, you can configure an Execution Snapshot. This schedule can automatically generate a copy of the report every day that will be used whenever someone tries to view the report, thereby significantly improving the reporting experience. When you are determining factors for configuring a schedule, consider the following items.

  • **Timing **  Schedule the snapshot to be run after 4:00 A.M. to make sure that the Data Transformation Services (DTS) job has time to be completed.

  • Report Execution Timeout   Set to "Do not time out report execution."

For background and detailed information about this task, see Reporting Service Books Online that was installed with the SQL Reporting Service.