Operations Manager 2007 SQL Queries

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)