Database Reference
In-Depth Information
How to do it...
The reporting capability for all the System Center components is rooted in their use of Mi-
crosoft SQL databases. The reporting databases for each of the components are listed in the
following table:
System
Center com-
ponent
Default installation re-
porting database
Additional information
Configuration
Manager
CM_<Site Code>
There is one database for each Configuration Manager site.
Data Protec-
tion Manager
DPMDB_<DPM Server
Name>
This is the default database for the DPM server. Additional information is written to the Opera-
tions Manager database if this optional integration is configured.
Orchestrator
Orchestrator
This is the default name when you install Orchestrator.
Operations
Manager
OperationsManagerDW
You must install the reporting components to create and populate this database.
This is the default reporting database. You have the option to configure two additional databases
known as
OMDataMart
and
CMDataMart
. Additionally, SQL Analysis Services creates a data-
base called
DWASDataBase
that uses
DWDataMart
as a source.
Service Man-
ager
DWDataMart
Virtual
Machine
Manager
This is the default database for the VMM server. Additional information is written to the Opera-
tions Manager database if this optional integration is configured.
VirtualManagerDB
Use the steps in the following sections to view the schema of the reporting database of each
of the System Center components.
Configuration Manager
Use the following steps:
1. Identify the database server and instance of the Configuration Manager site.
2. Use
Microsoft SQL Server Management Studio
(
MSSMS
) to connect to the
database server. You must connect with a user account with the appropriate permis-
sion to view the Configuration Manager database.
3. Navigate to
Databases
|
CM_<site code>
|
Views
, as shown in the following
screenshot:
