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?
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.
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!