-
Get alerts from Management Servers using SQL
There’s a lot of ways we can retrieve a list of alerts from SCOM, but nothings quicker than going to the Database directly. So here’s a bit of SQL that can grab all alerts from a Management Server, but formats the output a bit nicer. So for example rather than outputting the severity as a […]
-
How to get the number of alerts in the last 24 hours using SQL
Here’s how to get the number of alerts in the last 24 hours using SQL. Thanks Michael for the question. SELECT COUNT(*) AS [Number of Alerts per Day] FROM Alert WITH (NOLOCK) WHERE TimeAdded > dateadd(hh,-24,getutcdate()) Hope that helps.
-
SCOM Alert Description Variables
So you want to create an alert for your new SCOM Monitor or Rule but you don’t know what values you need to insert into the Alert Description?