OpsMgr 2007 - Get-Alert Examples
From a request on the SystemCenterCommunity a user wanted a SQL query to disply the following information: Managed computer, Alert description and Alert severity. Well its much easier to just open up Powershell and get this information, and slap it into a csv fie.
get-alert | select-object NetbiosComputerName, Description, Severity | Export-Csv -path “c:\alerts.csv“