Tag Archives: severity

SQL query to get alert history by severity and priority from scom datawarehouse

Below is a fantastic SQL query to run against your scom datawarehouse database which will output all alerts by source, category, severity and priority and will also give details of the monitor or rule that triggered the alert as well … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

SQL query to produce number of alerts by Severity between 2 dates

Here is a useful SQL query that you can run against your scom datawarehouse database which will produce a total count of alerts from dates you specify in the query. NOTE:-The query below worked against my SQL Server 2008 R2 … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , , , | Leave a comment

Extract Alerts to csv file according to resolution state and severity

Powershell to extract alerts and put them in a csv file according to resolution state and severity. Values to use…….. Resolution State              Severity Values for Alerts 0       =   New                          0 = INFORMATIONAL 255   =   Closed                      1 = WARNING                                                   2=  … Continue reading

Posted in Powershell for SCOM | Tagged , , , , , , , , , , , , , , | Leave a comment