Overview of Reporting in Operations Manager 2007

  • Artigo

Aplica-se a: Operations Manager 2007 R2

Microsoft System Center Operations Manager 2007 collects large amounts of data from your environment. You can create reports based on this data that provide additional information about the health of your environment. For example, you can create a report that shows the amount of time it takes between an alert being raised to its being written in the OperationsManager database. This report can help you identify any network delays and isolate trouble spots. Based on the data in the report, you can take corrective actions.

This guide provides information about how to use reports to address key monitoring scenarios, such as monitoring the availability of servers in your environment.

Before you can use the Reporting feature, you need to install the Reporting components, as described in the Operations Manager 2007 R2 Deployment Guide.

Reports

Operations Manager supports the following report types:

  • Published reports—These reports are automatically available in the Operations console after you install Operations Manager and the Reporting feature. These predefined reports are generic, allowing you to easily configure them to meet the needs of your organization.

    The Microsoft Generic Report Library contains some of the predefined reports. You can use these reports with any management pack and with most standard Operations Manager 2007 data types. Unlike predefined reports in Microsoft Operations Manager (MOM) 2005, these generic reports can be used even if the management pack does not include reports.

  • Linked reports—These reports are based on existing reports from the Generic Report Library. These reports are defined in custom management packs, and they are available in the Operations console, in the Reporting pane.

  • Custom reports—These reports are authored from queries that you build in Microsoft Visual Studio. There are several levels of customization: simple, moderate, and advanced.

  • Report solution—These reports are defined with Visual Studio and are available in a management pack. This customization requires the highest level of expertise. This guide does not provide guidance for creating this type of report.

Reporting components

Operations Manager 2007 Reporting is based on Microsoft SQL Server and SQL Server Reporting Services (SSRS). The following components make up Reporting.

Databases

There are two databases used for reporting:

  • OperationsManager—Contains the configuration information for the management group, management packs, and the performance, event data, and alerts that are collected and processed by agents.

  • OperationsManagerDW—Contains data that has been processed and prepared for reports. Common objects and attributes are stored in the shared area of the database. Other data, primarily unique data types, is stored in a separate, non-shared area of the database. Multiple management groups can store data in a single OperationsManagerDW database.

Typically, these two databases synchronize every 30 seconds to ensure that the OperationsManagerDW database is up to date.

Data Warehouse Server

The Data Warehouse server hosts the OperationsManagerDW database.

Management Server

The management server processes Write actions that are included in management packs. Write actions are instructions for writing performance and event data to the OperationsManagerDB database.

Operations Manager Reporting Server

The Reporting server builds and presents reports. It runs Microsoft Internet Information Services (IIS) with the Microsoft SQL Server Reporting Services (SSRS) Web site and services.

The Reporting server and the Data Warehouse server can be deployed on the same server or on separate servers.

The Reporting server must be located in the same domain as the Operations Manager 2007 system or in a trusted domain. Each management group requires a separate instance of SQL Server with SQL Server Reporting Services.

Reporting Data Warehouse

The Reporting data warehouse manages the OperationsManagerDW database. You can set up this component from Operations Manager Setup.

Management Packs

Management packs contain predefined reports to gather information about the target of the management pack. For example, the SQL Server management pack includes reports targeted to gather information unique to SQL servers.