Useful SCOM SQL Queries
Posted by Jeremy D. Pavleck on 10th June 2008
I’m essentially mirroring this from the original one on my blog, but since I’ve decided to transition to a tech blog and a non-tech blog, it seems like a good idea.
I’ve taken the listing of SQL queries from Kevin Holman’s original post, cleaned them up a bit, and made it into one file which you can download and load into SQL Studio Manager, instead of copying and pasting individual queries. I’ll also be showing you how to automate a lot of these with PoSh, but right now I’m swamped and haven’t had the time to clean things up proper - so you’ll just have to wait.
Download Useful SCOM 2007 SQL Queries.sql
Read on to see what’s in the actual file
Posted in SCOM, SQL | No Comments »