alert counter

Question & Answer
#1

Hi all,

 

I would do some alert counter. I explain:

 

I want to have 3 counters on a dashboard that say the number of alerts opened for a specific server/service:

 

Critical: xx alerts

Warning: xx alerts

Information: xx alerts

 

Is it possible? how to do this?

 

thanks,

 

Laurent

#2

Hi Laurent,

A SQL query would do this for you quite nicely. Kevin Holman has provided a few that you should be able to modify to your needs.

https://blogs.technet.microsoft.com/kevinholman/2016/11/11/scom-sql-queries/

If you have any luck getting the query to show alerts for a specific computer and severity, please can you post back for the rest of the community to consume!

Thanks,

Jelly

1 Like