Database Reference
In-Depth Information
Getting ready
It is recommended that you read the
Understanding the OperationsManagerDW schema
re-
cipe earlier in this chapter before following this recipe. You will need to prepare your en-
vironment to author reports by following the instructions in the
Preparing your environ-
ment to author reports
recipe.
State dataset
The state dataset can be used to create availability reports. This data is collected by the
monitors in Operations Manager. The views available in the state dataset contain informa-
tion about the state of your managed entities. All views are stored in the
State
database
schema.
A monitored object can be in different states. These states are known in Operations Man-
ager and recorded in views. The views available in the state dataset include one column for
the number of milliseconds the object has been in this state over a particular period. These
columns are as follows:
•
InRedStateMilliseconds
: This means that object was in critical state
•
InYellowStateMilliseconds
: This means that object was in warning state
•
InDisabledStateMilliseconds
: This means that monitor was disabled
•
InPlannedMaintenanceMilliseconds
: This means that object was in
planned maintenance
•
InUnplannedMaintenanceMilliseconds
: This means that object was in
unplanned maintenance
•
HealthServiceUnavailableMilliseconds
: The health service of the
object was unavailable
State.vStateHourly and State.vStateDaily
The
State.vStateDaily
and
State.vStateHourly
views contain aggregated
state information by day and by hour, respectively.
You can join the
vManagedEntityMonitor
view on the
ManagedEntityMonit-
orRowId
column. From this view, you can join the
vManagedEntity
view on the
ManagedEntityRowId
column to retrieve information about the managed entity, the
state that data is associated with it, and you can join the
vMonitor
view on the
Monit-
orRowId
column to retrieve information about the monitor that generated the state data.