appliedsql.net
SCOM -TSQL Script – Find active alerts in a SCOM managed environment
I had to write this query as SCOM dashboard doesn’t always give depict a proper view of the open active alerts in the system. This would be helpful for creating reports for SCOM or for monito…