RETRIEVE ALERT STATISTICS SQL DM

by Oct 26, 2016

Dear All, 

 

I am trying to understand if there is a procedure to retrieve alert stats from past one month.

scenario : lets say we are getting pages/s always reported from 200 servers as critical almost every day, few of those servers we have known issue but few we dont have any, and now i want to get in sql dm and then try to get a report, where it shows server names against which pages/s was critical reported. 

 

Can you please help ?

mshashan