Creating Reports for SCOM and SCVMM - Microsoft System Center Reporting - page 205

AD.CustomField1
FROM
Alert.vAlert A
LEFT OUTER JOIN Alert.vAlertDetail AD ON
A.AlertGuid = AD.AlertGuid
Alert.vAlertParameter
This view contains the value for each parameter in the alerts. 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,
AP.ParameterIndex,
AP.ParameterValue
FROM
Alert.vAlert A
LEFT OUTER JOIN Alert.vAlertParameter AP ON
A.AlertGuid = AP.AlertGuid
Note
Note that this is a one-to-many relationship, that is, the join can return multiple rows per
alert, one for each parameter.
Alert.vAlertResolutionState
The Alert.vAlertResolutionState view contains information about each resol-
ution state the alerts were in, such as the user and the date/time it was set and how many
seconds it was in this state. You can join this view to the Alert.vAlert view on the
AlertGuid column. You could also join the vResolutionState view on
Alert.vAlertResolution.ResolutionState = vResolu-
tionState.ResolutionStateId if you want to resolve more information about
the resolution state itself. Here is a sample query using the join to return resolution state
information:
SELECT
A.AlertGuid,