This SQL query will return information about the alerts that are currently in your MOM database.
SQL Query:
Select
Comp.Name,
Alert.Name,
Alert.Culprit,
'Alter Level' = Case
When Alert.AlertLevel = 10 Then 'Success'
When Alert.AlertLevel = 1 Then 'Windows NT Workstation'
When Alert.AlertLevel = 20 Then 'Information'
When Alert.AlertLevel = 30 Then 'Warning'
When Alert.AlertLevel = 40 Then 'Error'
When Alert.AlertLevel = 50 Then 'Critical Error'
When Alert.AlertLevel = 60 Then 'Security Breach'
When Alert.AlertLevel = 70 Then 'Service Unavailable'
Else 'Undetermined'
End,
'Resolution State' = Case
When Alert.ResolutionState = 0 Then 'New'
When Alert.ResolutionState = 85 Then 'Acknowledged'
When Alert.ResolutionState = 170 Then 'Assigned to a help desk or local support'
When Alert.ResolutionState = 180 Then 'Assigned to a subject matter expert'
When Alert.ResolutionState = 190 Then 'Requires scheduled maintenance'
When Alert.ResolutionState = 200 Then 'Assigned to an external group or vendor'
When Alert.ResolutionState = 255 Then 'Resolved'
Alert.RepeatCount 'Alert Count',
Convert(VarChar(10), Alert.TimeRaised, 101) 'Time Raised',
Convert(VarChar(10), Alert.TimeOfLastEvent, 101) 'Last Event'
From Computer Comp
Join Alert on Comp.IDComputer = Alert.IDComputer
Order By Comp.Name
No Comments