Get information of Resolved Alerts in OpsMgr 2007

Resolved Alerts in Operations Manager is easy to extract from your DW and Operations Manager environment:

In Powershell:

Get-Alert | Where {$_.Resolutionstate -eq 255} | ft resolvedby

Or if you need a query from OperationsManagerDW in SQL as a dataset in your report:

SELECT Alert.vAlert.AlertName, Alert.vAlertResolutionState.ResolutionState, Alert.vAlertDetail.Owner, Alert.vAlertDetail.TicketId,
       Alert.vAlertResolutionState.StateSetByUserId, Alert.vAlert.RepeatCount, Alert.vAlert.RaisedDateTime, Alert.vAlert.AlertDescription, vManagedEntity.Path
FROM   Alert.vAlert
INNER JOIN Alert.vAlertResolutionState ON Alert.vAlert.AlertGuid = Alert.vAlertResolutionState.AlertGuid
INNER JOIN Alert.vAlertDetail ON Alert.vAlertResolutionState.AlertGuid = Alert.vAlertDetail.AlertGuid
INNER JOIN vManagedEntity ON Alert.vAlert.ManagedEntityRowId = vManagedEntity.ManagedEntityRowId
Where (Alert.vAlertResolutionState = 255)

Thanks to Michael Westergaard for his question about Resolved Alerts....

By Kåre Rude Andersen|2009-12-18T10:57:54+01:00december 18th, 2009|Operations Manager (SCOM)|1 Kommentar

Om forfatteren: Kåre Rude Andersen

Microsoft Certified Trainer since 1996, MCSE, TS and ITP in Microsoft Windows, SQL (also Microsoft), Exchange (MS) and Microsoft Operations Manager. Senior Consultant and have recently worked as a consultant at CSC, SAS, ISS, Nokia and Scandlines.

En kommentar

Garth Jones december 27, 2013 af 20:26

There is a typo in your query. it should be

Where
(Alert.vAlertResolutionState.resolutionstate = 255)

Der er lukket for kommentarer.