Tag Archives: alert history

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 report on how many times a particular alert has triggered

Here is a very useful SQL Query that you can use to determine how many times a particular alert has fired, when it fired and what host it fired on. Open up Microsoft SQL Server Management Studio on your Datawarehouse … Continue reading

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