If you want to find out what objects are currently in Maintenance Mode, here’s a nice bit of SQL Code you can use for just that. I’ve added a more useful English Reason than just the code because SCOM stores the code itself in the Database. It’s a lot easier in my opinion to identify the reason as server was put into maintenance that just code 8 or 9.

Here it is, enjoy.

Read more

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

Merry Christmas!

Categories: Other
Comments: No

Hello everyone,

Thanks for your fantastic support and feedback this year, I really do appreciate it.

I just wanted to say Merry Christmas and have a Happy and Safe New Year! I’ll take a very short break and I’ll see you early next year with some great new SCOM Posts and Training Videos!

– Tim 🙂

 

In the previous video I ended with a short lecture on why it’s so important that you ensure that your agents work properly…in this video I pretty much start with the same lecture (haha). After that we begin to see how we can troubleshoot SCOM Agents. I talk about problems you might experience with manually installed agents versus discovery based installations. I discuss things like Gray agents, agents appearing in Pending Management, Certificates, the Health Service, Restarting the service, flushing the cache and how to read the windows event log.

13-troubleshooting-scom-agents

In this video I show you how you can set the Remotely Manageable flag on your agents to yes in the SQL Database. I also show you how to enable Agent Proxying for all agents but also how to configure SCOM so that all future agents you install also have the Agent Proxying feature turned on. Finally, I give you a bit of a lecture (lol) about why it’s so important that you ensure that your agents work properly!

12-windows-agents-part-2

Another video for you guys, this one shows you how to use the discovery wizard to install Windows Agents. We also unlock all of the required ports to use discovery in a firewalled environment. Next we install an agent manually and see how when we install an agent on a Domain Controller, the additional step of using the HSLockdown.exe tool is required.

You can download it right here: 11-installing-windows-agents

Another video for you guys, this one talks about what configuration changes I like to do after SCOM is installed. Things like setting the Service Principle Names (SPN’s), sizing the databases and memory, compressing backups and setting the Maximum Degree of Parallelism for SQL Server. In addition we review heartbeat settings and set manually installed agents to be reviewed instead of rejected.

You can download it right here: 10-post-installation-configuration