MOM Reporting Database Schema

  • Article

The MOM Reporting Database schema reference describes the SQL views included with the MOM Reporting Database.

In most respects, the Reporting Database schema is different from the MOM Operations Database schema. The Reporting Database schema is optimized for storing and querying historical operations data.

Knowledge about the MOM Reporting Database schema is needed if you are modifying or creating new reports with SQL Server 2000 Reporting Services and the MOM Reporting console. You will also need information about the schema if you are developing custom applications to analyze the data in the Reporting Database.

For convenience, the schema documentation is organized around three main areas:

  1. Rules Data
  2. Operations Data
  3. Discovery and State Monitoring Data

The Reporting Database schema also includes a set of views equivalent to the SDK views found in the MOM Operations Database, making it easier to migrate reports and tools created for MOM 2000 SP1. In cases where the view in the Reporting Database is not exactly the same as the corresponding SDK view in the operations database, the SDK Views documentation notes the differences.

Some of the views will generate the following message when queried: Warning: Null value is eliminated by an aggregate or other SET operation. You can safely ignore the messages or disable ANSI warnings.

See Also

Overview of the Reporting Database | MSDN Online: Designing a Data Warehouse | MSDN Online: Using a Data Warehouse | MSDN Online: Data Warehouse Design Considerations