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.

Report Datasets TSQL.zip

Comments

• Anonymous
  January 01, 2003
  Jonathan Almquist a publié un ensemble de requetse très interessantes et réutilisables dans vos rapports

• Anonymous
  January 01, 2003
  Jonathan Almquist a publié un ensemble de requetse très interessantes et réutilisables dans vos rapports

• Anonymous
  January 01, 2003
  Jonathan Almquist a publié un ensemble de requetse très interessantes et réutilisables dans vos rapports

• Anonymous
  November 01, 2011
  Extremely useful! thank you.