Tag Archives: alerts

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

Command channels not feeding alert info into custom EventLog

Environment= SCOM 2016  Management Servers=Windows Server 2016 Had an issue recently where I had created custom scom command channels to write custom alert information into a custom event log that I had created and it was not working. Full path … Continue reading

Posted in SCOM 2016 | Tagged , , , , , , , , , , | Leave a comment

Domain Controllers still generating alerts after being put into maintenance mode

A colleague of mine was doing some work on DC’s so put them into maintenance mode via the scom console, he was perplexed to discover that the DC’s started to generate alerts when he started work on them. Why did … Continue reading

Posted in Misc Stuff | Tagged , , , , , , , , , , , , , , , | Leave a comment

Open Alerts but Health Explorer shows Healthy

On occasions you can run into a situation where SCOM shows open alerts in the console (with a warning or error condition), but  when you open Health Explorer it shows that the monitored object is actually Healthy!?? Here’s a quick … Continue reading

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

Alerts still being generated after maintenance mode invoked

This issue could be caused due to the following reason: – The object that was put into Maintenance Mode is not generating the actual alert. To verify this, right-click “Active Alerts” view on the Operations Manager console and select “Personalize … Continue reading

Posted in SCOM 2012 SP1 | Tagged , , , , , , , , | Leave a comment

Not seeing alerts in custom Closed Alerts view

I  configured a view for all Closed Alerts in my SCOM console using the criteria Show data related to Object, Show data contained in a specific group (All), with specific resolution state with Closed (255) resolution Recently a colleague was … Continue reading

Posted in SCOM 2012 SP1 | 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

Close alerts generated by Rules from a specific MP

If you have lots of alerts generated by rules from a specific MP then you can use the following Powershell script to close them all. NOTE:-The example shown is for the Lync 2013 MP, you will need to change this … Continue reading

Posted in Management Packs, SCOM 2012 SP1 | Tagged , , , , , , , , , , , | Leave a comment

How to find out who closed an alert

If you go to “Closed Alerts” view, right click the view, select personalize. There you can add the “Resolved by” to the view and you will be able to see the user who closed the alert, anything resolved by OpsMgr … Continue reading

Posted in Misc Stuff | Tagged , , , , | Leave a comment