Operations Manager Command Shell Main Menu
Welcome to TechNet Blogs Sign in | Join | Help
Operations Manager 2007 SQL Queries

I’m starting a new post here, similar to my Command Shell reference.  This will include some useful SQL queries that I happen to need and direct my customers to on a daily basis.  If you don’t see something here, check Kevin Holman’s blog.  He’s already got a library of useful queries posted, in which I will not duplicate here.

I will continue to update this table periodically.  If you subscribe to my blog, you will receive each new example as I post it.

Note: The queries in each link are a direct paste from the SQL query editor.  They do not look pretty.  Simply copy the content into your query editor to see proper formatting.

Replace any text in red in each example with your specific parameters or criteria.

OperationsManager OperationsManagerDW
All groups  
All groups and their contained instances  
All disk sizes (GB)  
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
Posted: Saturday, April 25, 2009 4:05 AM by jtalmquist

Comments

Stefan Stranger's Weblog - Manage your IT Infrastructure said:

Jonathan Almquist started a blog post about Operations Manager 2007 SQL Queries . “I’m starting a new

# April 25, 2009 11:18 AM

Blog Opsmgr / SCOM 2007, and Windows 2008 , Seven ...in french said:

Jonathan Almquist a posté sur son blog un tableau des principales requêtes SQL. Cette initiative est...

# April 27, 2009 5:11 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker