Adhoc Query to Check Status of Servers and Active Alerts

by Jul 31, 2014

I’m needing to put together some adhoc queries to show the status of all monitored SQL Servers, whether Critical, Warning or OK.

I’m also needing to show the active alerts if any servers are critical or warning. Basically the same as the query that is used in the “Active Alerts” screen. I’ve tried profiling but didn’t manage to find what I need.

Anyone know which table and columns I need?