Database Reference
In-Depth Information
How it works...
The central repository that stores all data available for Service Manager reporting is the
DWDataMart
database. This database is located in the SQL Server that hosts the Service
Manager Data Warehouse databases and is also referred to as the Service Manager Data
Mart.
System Center Service Manager makes the data from the operational
CMDB
database
available in the
DWDataMart
database. The schema of the data mart is optimized for re-
porting.
The translation of entities in the CMDB to their respective representation in the data mart is
defined in management packs. These management packs are synchronized from the opera-
tional database to the data mart as part of the
MPSyncJob
data warehouse job.
Each entity type in the CMDB has its own representation in the data mart. Classes are rep-
resented as dimensions, relationships are represented as facts, and enumerations (aka lists)
are represented as outriggers. Service Manager creates views in the SQL database that you
can use to write queries for your reports.
SQL Server Report Builder and other tools used to author reports offer visual wizards to
create the queries you need to fuel your System Center reports. These tools, however, do
not remove the requirement for you to have at least a basic knowledge of the
Structured
Query Language
(
SQL
) used to query relational databases. A basic knowledge of SQL is
essential to create and edit Service Manager reports.
The Service Manager Data Warehouse data mart is documented and is part of the SM Job
Aids, which can be downloaded from the Microsoft website at
http://www.microsoft.com/
