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 ;-)
% Logical Disk Free Space on Windows Server 2003
Total Number of Servers per OS
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'.
Which SQL query are you running?