Database Reference
In-Depth Information
How to do it...
All the data relevant for reporting is exposed in views inside the
OperationsManager-
DW
database. The recommendations are you should not access the tables directly in your re-
port queries. Instead, it is recommended that you target the database views for your report-
ing needs. This recommendation is because Microsoft makes every effort to maintain the
schema of the views even when structural changes are made to the underlying tables.
In the
OperationsManagerDW
database, data is grouped into different categories,
which are also referred to as
datasets
. These datasets include the following:
• Alert dataset
• Event dataset
• Performance dataset
• State dataset
Additionally, there are more datasets for special monitoring capabilities of Operations
Manager, such as the
Application Performance Monitoring
(
APM
) dataset and
Client
Monitoring
dataset.
Managed entities
All data available in the various datasets reference monitored objects, management packs,
groups, and so on. This information can be retrieved using the
ManagedEntity
views.
The views available for managed entities are typically joined to other views in the alert,
event, and performance, or state datasets. These views resolve information about the mon-
itored object and allow you to scope your query to a specific group, management pack, or
management group.
vManagedEntity
The vManagedEntity view contains the names of all the objects in your Operations Man-
ager environment, such as computers, SQL databases, and IIS websites. Use the
Man-
agedEntityRowId
column to join this view to views from other datasets. Run the fol-
lowing query using the
OperationsManagerDW
database to view the details in your
environment:
SELECT
ManagedEntityRowId,
