SCOM 2012 & SCOM 2012 R2 Daily Check PowerShell Script & HTML Report v2.0…(Released!)

Its been a long time in development but I’m happy to announce my second SCOM Health Check script. This one is over 3500 lines of code, lots of css, html and javascript and its my gift to you guys, the SCOM Community.

So what does this new version offer? Firstly, a much, much nicer report. Fancy graphs, nice clean tables and some genuinely useful information about your SCOM Environment.

 

  • A Data Volume graph where you can instantly see the amount of Alerts, Events, Performance Data and State Changes over the last 7 days
  • The Health State of your SCOM Agents
  • A Graph of your Alert Statistics – how many Open or Closed Alerts
  • Your Management Server Health, Versions, Server Uptime & the number of Workflows they are running. Now updated to include Gateways! Also CPU, Disk and Memory Graphs for each!
  • Any Open Warning or Critical Alerts for your Gateways and Management Servers.
  • The Top 5 Alerts by Repeat Count (use this to identify recurring problems)
  • The Top 5 Events by Computer (see which computers are the noisiest)
  • Your Operational Database & Data Warehouse Servers…how much space they are using, free space, file sizes and locations.
  • Your Operational Database and Data Warehouse Backups. Make sure they are running.
  • Are the Databases being groomed? You’ll be able to tell instantly!
  • Find out what is using all of the space in your Operational Database & Data Warehouse Databases.
  • The Reporting Server and Web Console Server URL’s and if they are OK.
  • The Status of your Scheduled Reports
  • If there are any Overrides in the ‘Default Management Pack’
  • What Discoveries ran in the last 24 Hours and what Properties were changed?
  • Identify agents that are lower than the highest version installed. Use this to see which agents should be upgraded to the most current version
  • Identify Agents that are not Remoteable.
  • Is Agent Proxying Enabled?
  • What Objects are in Maintenance?
  • And it’s available in 2 different colors!

 

Hopefully you’ll find this script useful and it might help you identify problems, like this one:

This is clearly showing the DataWarehouse is out of space!

SQL OPDW Full

 

 

 

 

 

Instructions:

Simply unpack the zip file onto a SCOM Management Server and run the scom-dashboard.ps1 script (found in the script folder) from a PowerShell Console Window. When the script is finished you’ll find the report inside the “report” folder.

Thanks for trying out this new script! Download it here:Β Culham SCOM Dashboard v2.0!

 

 

A few notes:

Due to the heavy use of Javascript for the graphs this report in its current version is not able to be emailed. I’ve tested this in IE only as that’s the only browser I can be assured is on a SCOM Server.

Since this is the initial release, please try it in a lab before you try it in production. There’s no code that makes any changes so of course you should be safe, but you run it at your own risk πŸ™‚

If you want to make changes to this code, feel free but credit where its due would be nice. I have put a lot of work into this so I’d appreciate that…I’m not asking much.

Finally, if you think this report and indeed this site helps you out feel free to tell those fine folks at the Microsoft MVP Program all about it πŸ™‚ and if you have any questions, feedback or suggestions for improvement please let me know via the Contact PageΒ or email me at timculham@gmail.com.

 

 
Comments
Jonathan Pritchard

Tim, I’ve been waiting in eager anticipation since you first previewed your work on this. My god you have a good eye for graphic design too (as seen in your topology widgets too). Thank you for the awesome share. Going to make sure to send feedback to MS MVP πŸ™‚

Going to set this up now!

Also Tim, not sure if you’ve considered before, but would be great to see you on Twitter. I’ve been getting more into it in recent years and generally use it as a fancy RSS feed to bring together all the updates (like your awesome new post!) I care about, as well as providing me with a faster way to receive “the latest stuff”, and share it out again.

Will let you know my feedback πŸ™‚
Out of interest what have you found performance like in terms of time to generate the report?

Hi Jonathan,

Thank you for the terrific feedback I really do appreciate people taking the time to say hello. I have thought about Twitter yes, I guess it’s just another thing I have to get around to do πŸ™‚

Performance Wise, I’ve tested this script on environments with only a couple of agents and ones with several hundred. In fact I’ve tested it on over 20 different SCOM environments. I’ve found it to run in under a minute in almost all cases. Still if you have a lot of Management Servers and Gateways and thousands of agents your mileage will vary as you might expect.

Please let me know your feedback and keep popping back because I’m actually working on another Dashboard, this one is designed for Application Monitoring ie. An Exchange Dashboard for example and can easily be applied to other applications, Lync, SQL, SharePoint and so on. Ideally it would be something to throw onto an LCD at a company. Hopefully this one will be ready in a much quicker timeframe πŸ™‚ And personally, I think this one looks even better!

Hi Tim.

First of all, thank you so much for sharing this! It’s a opsmgr admin dream report. One question though, what is the prerequisite for the report? IE (v.11 on the MS) not responding when I open it. The script works fine, however I think i’ll implement a switch for SCOM 2007/2012 as it’s fail to import PS-snapin on my 2012 MS and will throw multible error regarding missing SCOM 2007 cmdlets. And a verbose parameter/switch (CommonParameters/CmdletBinding) as well with some more write-verbose to see what the status while the script is running.

Thanks again!

Hello, you’re most welcome.

I have tested this all the way up to Windows 2012 R2 with the default IE and none of them have given me any issues. Sometimes it can take a while to open on the larger reports.

Hello, I lauch your script but its not launched, I have error

You must provide a value expression on the right-hand side of the ‘-‘ operator.
At D:\sources\Culham SCOM Dashboard v2.0\script\scom-dashboard.ps1:1230 char:57
+ elseif ($ManagementServerAlert.ResolutionState – <<<< notin (0, 255)
+ CategoryInfo : ParserError: (:) [], ParseException
+ FullyQualifiedErrorId : ExpectedValueExpression

Can you contrΓ΄l your script ? thank you very mutch

Best Regard

Hello Tim

I found the problem I replaced the three lines -notin
by -contains and it’s ok now, I could start the script.

Best Regard

Hi Sami,

Glad you got it working. I think I used -notin and that’s a PowerShell v3 feature.

Hi,

This script works great in test SCOM env. But doesn’t work in production where we have multiple scom and gateway servers. Getting connot convert argument property value and timeout expired error when loading snapin.

Hi Vinay,

I’ve tested it against environments with a lot of Management Servers with up to 4 gateways and it worked fine. Admittedly some of the gateway servers may not return anything as they could be behind firewalls so they should return ‘unavailable’. Can you email me the errors you are getting?

Great Effort Tim.!! Would be great if could add the feature to email these reports & be able to view it on a Smart phone.

Many thanks for this script. Very good report!

Tim, I love this report. Not to mention the attention to details in the script itself. truly nice. I did notice the script assumes the reporting server DB exist in the same server hosting the OperationsManager and DataWarehouse DB which creates a minor error for me. Other than that….Amazing work man!

Trackbacks for this post

Leave a Reply