Install KB2783466 with SCCM to fix red cross in SUP packages

Last month we got problems! A lot of patches were missing from our packages and the solution was then to just re-download them all and update the distribution points.

Now Microsoft has released a patch for this "KB2783466" and I just deployed it using SCCM.

Create a normal software package and add the file and this commandline:

SCCM2007-SP2-KB2783466-ENU.msi /passive /norestart

Advertise it to some pilot servers and install it manually, since the switches are /passive you will see the installation but it's still automatic which gives you some control.

Check "add/remove programs" to see that it's installed ok.

Put in a mandatory installation time to the advertisement and rock on with the rest of your SCCM servers.

Use Wmic to Get Hotfix installation dates from Windows 7 and 2008 servers

The default setting in Def_Mof does not collect hotfix installation dates from Windows 2008 servers so you can't use SCCM to query add/remove programs table to get a installation date when SUP is giving strange dates.

So I searched and modified a powerful wmic command for this:

wmic /node:@serverlist.txt /output:c:\temp\qfe_output.csv QFE where hotfixid="KB2655992" GET CSName,HotFixID,InstalledON /format:csv

1. Put all servers into the "serverlist.txt" file.

2. Run the command as a user who gets local admin rights to all systems in the serverlist.txt.

3. Outpul is created as CSV but you can change the formal to HTML by changing to: "/format:html"

Worked very well for me!