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 Service Manager Data Warehouse data mart

The purpose of this recipe is to describe the database schema of the Service Manager Data Warehouse data mart. Knowing the anatomy and design of the data mart is key to successfully creating custom reports for System Center Service Manager.

Getting ready

You need to have a fully deployed Service Manager 2012 SP1/R2 environment that includes a registered Data Warehouse Management server with its prerequisite databases.

You will also need SQL Server connection rights to the Data Warehouse database server that allows you to view and read objects using Microsoft SQL Server Management Studio (MSSMS).

A basic knowledge of SQL query syntax is recommended.

How to do it...

All data relevant for reporting ...

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