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.
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.
All data relevant for reporting ...