Tag Archives: alert report

Powershell to send Top 15 Critical Alerts email from Scom

Here is a nifty powershell script that you can use to send an email with the Top 15 Critical Alerts in your Scom Management group to recipients of your choice. NOTE:-Amend the addresses in the script with @mycompany.com suffix to … Continue reading

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

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