My Operations Manager 2007 SQL Queries

My Operations Manager 2007 SQL Queries

  • Comments 4
  • Likes

Jonathan Almquist started a blog post about 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.”

I also have some SQL queries I used at customers I want to share. Would be nice if we had some kind of Wiki where we could post all our OpsMgr SQL queries though ;-)

OperationsManager OperationsManagerDW
  Logical Free Megabytes on Windows Server 2000 and higher

% Logical Disk Free Space on Windows Server 2003

List all Windows Computers  

Total Number of Servers per OS

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Some of us were just discussing a Wiki for this type of material.  I think this type of content is great candidate for Wiki style posts.

  • I get an error stating

    Server: Msg 208, Level 16, State 1, Line 1

    Invalid object name 'Perf.vPerfDaily'.

    Please advice

  • Hi Jesty,

    Which SQL query are you running?


  • Stefan, I got the same error as Jesty, actually, I think you need to identify in which database you are running your queries.

    (BTW, I am a sql server DBA)