Archive for March, 2017

I’ve had so much positive feedback about my original SCOM Health Check Script and also the updated v2 one which a lot of people thanked me for updating it with the fresh new style. However I also got some great feedback asking if I could turn it into a SCOM Report that could be run, scheduled and emailed from SCOM itself. Then you’ll be pleased to know that I’ve been working on it and soon plan to release my version 1.0 SCOM Health Check Report. So this new report will be like the previous one as far as content goes, giving you the same sort of information, except instead of being written in Windows PowerShell I wrote this using SQL Queries and SQL Report Builder. I’ve then taken that and populated it into a SCOM Management Pack so you guys can simply import it straight into SCOM and schedule it to email you…how easy is that!

It has a slightly different look to my previous reports and I’m still playing around with styles so I haven’t actually settled on a final one but it will most likely look something like this..

SCOM Report v1.0

 

 

 

 

 

 

 

Read more

There’s a lot of ways we can retrieve a list of alerts from SCOM, but nothings quicker than going to the Database directly. So here’s a bit of SQL that can grab all alerts from a Management Server, but formats the output a bit nicer. So for example rather than outputting the severity as a 0, 1 or 2…it outputs the english word, Informational, Warning or Critical. Same with the Monitor or Rule. Just a bit easier to read than working out if a 0 or a 1 is a monitor or rule.

Read more