Database Reference
In-Depth Information
A.AlertName,
A.RaisedDateTime,
RS.ResolutionStateName,
AR.StateSetDateTime,
AR.StateSetByUserId
FROM
Alert.vAlert A
LEFT OUTER JOIN Alert.vAlertResolutionState AR ON
A.AlertGuid = AR.AlertGuid
LEFT OUTER JOIN vResolutionState RS ON
AR.ResolutionState = RS.ResolutionStateId
The following screenshot provides a visual view of the all the join relationships discussed
in this section:
