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

  • Comments 4
  • Likes

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)
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   





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

Comments
  • <p>Jonathan Almquist started a blog post about Operations Manager 2007 SQL Queries . “I’m starting a new</p>

  • <p>Jonathan Almquist a post&#233; sur son blog un tableau des principales requ&#234;tes SQL. Cette initiative est...</p>

  • <p>Nice list, thanks. As the base I used a query from your list. Then I used that query as derative to count and calculate the average number of events per day. Easy/simple but effective.</p> <p><a rel="nofollow" target="_new" href="http://michielw.blogspot.com/2010/09/scom-average-events-per-day-keeps.html">michielw.blogspot.com/.../scom-average-events-per-day-keeps.html</a></p>

  • <p>Very nice list. &nbsp;Is there a SQL query to determine what subscription an objects is tided to? </p>