System Center Operations Manager 2007 usefull SQL Queries

I will try to often update this post with the SQLqueries I've found or developped for specific report needs.

Last update : 2012/03/07

• Retrieve discovered objects for a specific class
• List SCOM groups for a list of servers
• Get SCOM Groups members using a SQL Query on OperationsManager DB
• List all Manual Reset Monitors