There is always a problem with unwanted alerts in SCOM during patch windows when server reboots etc. I want to show you a concept which combines different tools for an automated solution.
This concept assumes you are using WSUS and GPO settings with configured automatic updates scoped to AD groups.
Here are the overall steps:
1. Populate SCOM Groups with members from the AD Groups used in WSUS.
2. Schedule these SCOM Groups in align with the reboot schedule of the WSUS GPO settings.
Creating and Populating SCOM Groups based on corresponding AD Groups
First of all we need to create SCOM groups and populate them with Windows computer objects with the corresponding AD Groups used in WSUS.
Arjan Vroege has made a great Management Pack that accomplish this. It is described on his blog here http://www.vroege.biz/?p=819 or can be directly downloaded from technet
Once you have the corresponding SCOM groups populated with Windows Computers Objects we are all set. In my enviroment I have several WSUS groups.
The Windows Computers in one of the above Groups.
Scheduling Maintenance Mode
There are different examples and concepts on the web to schedule Maintenance Mode in SCOM. By Powershell Script, Orchestrator etc.
In this example I will use Tim McFaddens great tool Maintenance Mode Scheduler http://www.scom2k7.com/scom-2012-maintenance-mode-scheduler
Look up The SCOM Group you want to schedule Maintenance Mode for. Set the time-window (Start Time and End Time) to allow the patches to be installed and the computers restarted according to your WSUS GPO settings. Do this for the rest of your groups as well.
If you have setup the Schedule correctly the servers will go into Maintenance Mode during patching and you will not have a bunch of Alerts in SCOM.
Building a dashboard in Squared Up
If you are a big fan of Squared Up for SCOM like I am we can build a nice dashboard to show the numbers of servers in each SCOM WSUS Group. This could be valuable for your team that does the patching.
In Squared Up, choose SQL Query Content.
In the Connection field, enter the values to your Operations Manager DB
In the Query field, enter the Query below (Remember to change the Group Names so you get all your SCOM Groups)
Change to ‘tabular’
select SourceObjectDisplayName as ‘Group Name’,
Count(TargetObjectDisplayName) as ‘Number’
AND SourceObjectDisplayName like ‘<Your SCOM WSUS group names here>’ group by SourceObjectDisplayName
ORDER BY SourceObjectDisplayName
And we get an nice view of the groups and the number of Computer Objects in each group.