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 [...]
Category: Operations Manager 2007 | Comment
Posts tagged ‘Operations Manager Alerts’
