Database Reference
In-Depth Information
• If
Alert.vAlert.MonitorAlertInd
equals
0
, then join
vRule
to
vAlert.vAlert.WorkflowRowId = vRule.RuleRowId
You can join
Alert.vAlert
to
vManagedEntity
on
Alert.vAlert.ManagedEntityRowId = vMan-
agedEntity.ManagedEntityRowId
to retrieve information about the object that
the alert is associated with.
The following sample query returns all the alerts in the
OperationsManagerDW
data-
base, including the triggering rule or monitor and the associated managed entity:
SELECT
A.AlertGuid,
A.AlertName,
A.RaisedDateTime,
CASE A.MonitorAlertInd WHEN 1 THEN M.MonitorDefaultName
WHEN 0 THEN R.RuleDefaultName END AS WorkflowDefaultName,
E.FullName AS ManagedEntityFullName
FROM
Alert.vAlert A
LEFT OUTER JOIN vMonitor M ON
A.WorkflowRowId = M.MonitorRowId
LEFT OUTER JOIN vRule R ON
A.WorkflowRowId = R.RuleRowId
LEFT OUTER JOIN vManagedEntity E ON
A.ManagedEntityRowId = E.ManagedEntityRowId
Alert.vAlertDetail
The
Alert.vAlertDetail
view contains advanced information on the individual
alerts, such as
Owner
,
TicketId
, and all the custom fields. You can join this view to
the
Alert.vAlert
view on the
AlertGuid
column, as shown in the following query:
SELECT
A.AlertGuid,
A.AlertName,
A.RaisedDateTime,
AD.Owner,
AD.TicketId,