Hello friends! Yes, I know, it’s been awhile. I’ve been busy working. Now, not so busy, not so much working. So if you’re hiring, well let me know.

One of the reasons I reduced the amount of posting I did was I had already done all of the cool stuff you could do with SCOM. The regular day-to-day BS maintenance stuff is not fun for me. Nor is reposting every single press release Microsoft releases like a lot of my brethren. So I didn’t post much, just did my own thing.

But now with the upcoming release of Operations Manager 2012 there will be so many new, cool things to do with it! Not to mention I’ve extended my System Center fun to the other members of the family, and we should see some cool stuff happening.

To kick things off I’ve cleaned up and added to my Useful SCOM SQL Queries list. I’ve also uploaded it as both a PDF and as a .SQL file. So you can play with that for the time being while I finish up a few other things I’m working on.

 

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

Continue reading »

© 2012 Pavleck.NET Suffusion theme by Sayontan Sinha