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

Operations Manager 2007 SQL Queries

Operations Manager 2007 SQL Queries

Rate This
  • Comments 3

Sharing this list of random SQL queries I have found useful on different occasions.  Refer to report dataset samples page for SQL queries you can use for custom reporting needs.

Updated: 08-05-2011

OperationsManager OperationsManagerDW
All groups DW Retention and Groom Settings
All groups and their contained instances Discovery Check
All disk sizes (GB) All groups (DW)
Operational groom settings Group members (DW)
   Return all dirty aggregations in last X days
(new)
   Count dirty aggregations in last X days
(new)
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   





What do you think about this post?
Leave a Comment
  • Post
What others have said about this post...
Comments
Page 1 of 1 (3 items)