O'Reilly logo

Microsoft System Center Reporting Cookbook by Samuel Erskine, Dieter Gasser, Kurt Van Hoecke, Nasira Ismail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding the OperationsManagerDW schema

The purpose of this recipe is to describe the database schema of the OperationsManagerDW database. Knowing the anatomy and the design of this database is the key to successfully creating custom reports for System Center Operations Manager.

Getting ready

The central repository that stores all the data available for Operations Manager reporting is the OperationsManagerDW database.

SQL Server Report Builder and other tools used to author reports offer visual wizards to create the queries that will be used to retrieve data from the OperationsManagewDW database. You must also have a basic knowledge of the Structured Query Language (SQL) used to query relational databases.

How to do it...

All the data relevant ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required