My Operations Manager 2007 SQL Queries

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


Comments (4)

  1. Anonymous says:

    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.

  2. Anonymous says:

    Hi Jesty,

    Which SQL query are you running?


  3. Jesty says:

    I get an error stating

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

    Invalid object name 'Perf.vPerfDaily'.

    Please advice

  4. jyao says:

    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)

Skip to main content