SCOM Report: Resolved Alerts (By Analyst)
Sometimes you want to know who have closed some alerts, then using this report you can have a list to get this info. Take a look:
|
SCOM Resolved Alerts (By Analyst) |
|
USE
OperationsManagerDW
SELECT
Alert.vAlert.AlertName AS 'Name',
Alert.vAlert.AlertDescription AS 'Description',
Alert.vAlertResolutionState.StateSetByUserId AS 'Resolved By',
Alert.vAlertResolutionState.StateSetDateTime AS 'Date'
FROM
Alert.vAlert INNER JOIN
Alert.vAlertResolutionState ON Alert.vAlert.AlertGuid = Alert.vAlertResolutionState.AlertGuid
WHERE
(Alert.vAlertResolutionState.ResolutionState = 255)
ORDER BY 'Resolved By'
|