Yann Gainche's Weblog

Le blog d'un consultant qui cause de MOM, SCOM, SCE, PowerShell, ISA et peut-être même d'autres choses...

OpsMgr 2007 : Qui ferme les alertes ?

Voila une question qui m'a été posée récemment : Quel opérateur a fermé cette alerte ?

Une requête SQL sur la base OperationsManagerDW permet de répondre à cette question :

USE OperationsManagerDW

SELECT

Alert.vAlert.AlertName,

vManagedEntity.Path,

Alert.vAlertResolutionState.TimeFromRaisedSeconds,

Alert.vAlertResolutionState.StateSetDateTime,

Alert.vAlertResolutionState.StateSetByUserID

FROM Alert.vAlertDetail INNER JOIN

Alert.vAlert ON Alert.vAlertDetail.AlertGuid = Alert.vAlert.AlertGuid INNER JOIN

vManagedEntity ON Alert.vAlert.ManagedEntityRowId = vManagedEntity.ManagedEntityRowId INNER JOIN

Alert.vAlertResolutionState ON Alert.vAlert.AlertGuid = Alert.vAlertResolutionState.AlertGuid INNER JOIN

vResolutionState ON Alert.vAlertResolutionState.ResolutionState = vResolutionState.ResolutionStateId

WHERE Alert.vAlert.RaisedDateTime BETWEEN getutcdate()-7 AND getutcdate()

AND Alert.vAlert.AlertName <> ''

AND vResolutionState.ResolutionStateName = 'Closed'

AND Alert.vAlertResolutionState.StateSetByUserID <> 'System'

ORDER BY Alert.vAlert.AlertName

Posted: Apr 16 2008, 09:47 AM by Yann Gainche | with no comments
Filed under:
Leave a Comment

(required) 

(required) 

(optional)

(required)