Command Shell Examples
Useful SQL Queries
Report Dataset Samples - Jonathan Almquist on Operations Manager - Site Home - TechNet Blogs

Report Dataset Samples

Report Dataset Samples

  • Comments 4
  • Likes

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)
http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-monitor-generated-alerts-report-dataset.aspx

·        Top alert generating rules (tuning)
http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/08/top-rule-generated-alerts-report-dataset.aspx

·        Top alert generating rules with suppression – repeating (tuning)
http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-active-repeating-alerts-report-dataset.aspx

·        Top event collection rules (tuning)
http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-events-collected-report-dataset.aspx

·        Top performance collection rules (tuning)
http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/top-performance-samples-collected-report-dataset.aspx

·        Number of state changes per day (trending)
http://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)
http://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)
http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/09/number-of-performance-samples-per-day-report-dataset.aspx

·        Gray agents with reason (health)
http://blogs.technet.com/b/jonathanalmquist/archive/2011/04/08/gray-agents-with-reason.aspx

·        Root Management Server Unavailable History with Reason (health)
http://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)
http://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!
http://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.

Attachment: Report Datasets TSQL.zip

I do not moderate this blog anymore. If you have a question regarding this post, send me a message.

Comments
  • Jonathan Almquist a publié un ensemble de requetse très interessantes et réutilisables dans vos rapports

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

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

  • Extremely useful! thank you.