Report Dataset Samples
Putting this list of reporting dataset samples out here for your custom reporting needs or just to paste in for general purpose queries to the Data Warehouse. I’ll update this list when I have new datasets to share.
Updated: 09-23-2011
· Top alert generating monitors (tuning)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-monitor-generated-alerts-report-dataset.aspx
· Top alert generating rules (tuning)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/08/top-rule-generated-alerts-report-dataset.aspx
· Top alert generating rules with suppression – repeating (tuning)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-active-repeating-alerts-report-dataset.aspx
· Top event collection rules (tuning)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-events-collected-report-dataset.aspx
· Top performance collection rules (tuning)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-performance-samples-collected-report-dataset.aspx
· Number of state changes per day (trending)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/number-of-state-change-events-per-day-report-dataset.aspx
· Number of events collected per day (trending)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/number-of-events-collected-per-day-report-dataset.aspx
· Number of performance samples per day (trending)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/number-of-performance-samples-per-day-report-dataset.aspx
· Gray agents with reason (health)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/08/gray-agents-with-reason.aspx
· Root Management Server Unavailable History with Reason (health)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/04/19/root-management-server-unavailable-history-with-reason.aspx
· Heartbeat Failure and Failed to Connect Alerts with Durations (tuning)
https://blogs.technet.com/b/jonathanalmquist/archive/2011/05/13/heartbeat-failure-and-failed-to-connect-alerts-with-duration.aspx
· Group Picker Drop-Down List (parameter control) NEW!
https://blogs.technet.com/b/jonathanalmquist/archive/2011/09/23/pulling-back-groups-for-use-in-a-report-drop-down-list-group-picker.aspx
Note: I use a code snippet plugin on these pages, which aren’t very format friendly when you try to copy/paste. You can download all TSQL scripts at the bottom of this page.