Welcome to TechNet Blogs Sign in | Join | Help

A report to show all agents missing a specific hotfix

This is a continuation of my previous post on determining which agents are missing a hot-fix:

How do I know which hotfixes have been applied to which agents-

I wrote up a report that allows you to paste in a KB article number into the report as a parameter, and then it will show all agents that are potentially missing that hotfix.  This will help you easily find agent which need to be patched and got missed for some reason.

You can run this report if you create the SQL reporting data source as specified in my previous post:

Creating a new data source for reporting against the Operational Database

Once imported - it will show up in the console.  Open the report, and paste in any KB article number for a OpsMgr hotfix you have applied.  The number MUST begin and end with "%".... such as %951380% as shown:

 

image

The report is attached below:

Published Friday, June 27, 2008 11:11 PM by kevinhol
Filed under: , ,

Attachment(s): Agents_Missing_Hotfix_Report.rdl

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Kevin Holman's OpsMgr Blog : How do I know which hotfixes have been applied to which agents?

Friday, June 27, 2008 6:13 PM by Kevin Holman's OpsMgr Blog : How do I know which hotfixes have been applied to which agents?

PingBack from http://blogs.technet.com/kevinholman/archive/2008/06/24/how-do-i-know-which-hotfixes-have-been-applied-to-which-agents.aspx

# Sadly the PatchList field is limited to 256 chars

Tuesday, July 08, 2008 5:07 AM by brandubh

... this means that we quickly lose any record of the actual patches installed. Guys we cannot lose control of the patch level of the agents, I cannot think of having to develop my own rule to collect the applied patches from wmi or being forced to use sccm just to know which agents are up to date and which are not.

Please fix it.

# re: A report to show all agents missing a specific hotfix

Monday, September 22, 2008 2:01 PM by John W.

Kevin -

How do you re-apply patches that never got applied? In a response to Ian Blyth you said the following: "putting agents in pending is just flipping a bit in the database and putting them in the pending actions table".

Can you reply back with just how to do this? As we have a number of agents that need to have the hotfixes applied.

Thanks in advance.

Cheers,

John

# re: How do you re-apply patches that never got applied?

Monday, September 22, 2008 2:40 PM by kevinhol

If you have agents that did not get the hotfix applied - or you accidentally rejected the pending action for update - or the pending update action failed....

Simply "Repair" the agent under "Agent Managed" Administration view.

# How do I know which Hotfixes have been applied to which agents in OpsMgr 2007?

Tuesday, October 14, 2008 6:38 AM by Rantings of an IT Pirate

I was recently researching this very issue and found this very useful blog post originally made by Kevin

# How do I know which Hotfixes have been applied to which agents in OpsMgr 2007?

Tuesday, October 14, 2008 7:22 AM by Brad Bird at myITforum.com

I was recently researching this very issue and found this very useful blog post originally made by Kevin

# re: A report to show all agents missing a specific hotfix

Tuesday, October 28, 2008 11:27 AM by Ian Zarzuela

After applying the hotfix and following the SQL process on 956240, my version of Microsoft.mom.dataaccesslayer.dll is still 6.0.6278.0. Any advise?

# re: 956240, my version of Microsoft.mom.dataaccesslayer.dll is still 6.0.6278.0

Tuesday, October 28, 2008 11:42 AM by kevinhol

I have seen this in the field on occassion.... I'd recommend opeining a case with PSS.... or you can try the Windows Installer registry workaround I posted at http://blogs.technet.com/kevinholman/archive/2008/09/24/installing-the-web-console-on-a-2008-management-server-using-windows-authentication.aspx

# New OpsMgr hotfix – 958253 – Fixes patchlist table view for agent hotfixes

Tuesday, January 27, 2009 12:45 PM by Kevin Holman's OpsMgr Blog

Hey guys – a new hotfix is published, and I recommend this for all SP1 environments.  This cleans

# Which hotfixes should I apply?

Tuesday, January 27, 2009 12:49 PM by Kevin Holman's OpsMgr Blog

  In general - you should evaluate all hotfixes available, and only apply those applicable to your

# Aktualizace pro SCOM 2007 SP1 (hotfixes)

Sunday, February 15, 2009 11:51 AM by Nejde jen o software...

Uvádím zde seznam důležitých oprav pro SCOM 2007 SP1, které používám a doporučuji nasadit v každém prostředí.

# SCOM 2007 SP1 na Windows 2008 spolu se SQL 2008 (5)

Friday, March 27, 2009 12:26 PM by Nejde jen o software...

V tomto pokračování naleznete aktualizace pro SCOM 2007 SP1 ( Aktualizace pro SCOM 2007 SP1 (hotfixes)

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker