SCSM Console Cumulative updates management using SCCM 2007

SCSM cumulative updates often require all management consoles to be updated once the infrastructure servers are updated. If you have a large amount of consoles this can be tedious.

See my previous post for infrastructure upgrade steps:

https://itprocessed.com/2011/12/upgrading-scsm-2010-sp1-to-cu3/

With System Center Configuration Manager 2007 (SCCM 2007) the process is simple.

· Download the CU executable

· Created a Directory called Extracted

· Use 7z to extract the msp file and associated files

· In SCCM create a package and program to install (e.g. silent command: msiexec /p SCSM2010SP1_CU_KB2588492_i386_7.0.6555.128.msp /qn)

· Create a query based collection to find all SCSM installed consoles (use Workstation operating system filter)

· Create Advertisement to deploy

· Schedule the deployment after the Infrastructure update https://itprocessed.com/2011/12/upgrading-scsm-2010-sp1-to-cu3/

Detailed Steps:

Extract the CU exe to a directory using an extractor (e.g. 7zip)
In the SCCM Console |Computer Management |Software Distribution |PackagesCreate a New Package
Provide a name and optionally a comment
Specify the Source directory for the extracted update files (navigate to the SCSM Patch folder)
Next
Next
Next |Next|Next
Close
Create the Install Program
msiexec /p SCSM2010SP1_CU_KB2588492_i386_7.0.6555.128.msp /qn
Configure as required and click Next
Change to Whether or not a user is logged on to ensure silent installation is successful
Configure as required and click Next
Next
Next
Review summary and click Next
Close
Add to Distribution Point(s)
Next
Select only standard distribution points (do not select the PXE)
Close

Create a Query Based Collection (SCSM Installed Consoles)

select * from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like “Microsoft System Center Service Manager SP1” and SMS_R_System.OperatingSystemNameandVersion like “Microsoft Windows NT Workstation%”

SCCM Console |Computer Management |Collections |New Collection
Provide a name and appropriate comment for the collection
Click on the database icon to invoke the query based collection Wizard
Provide a name for the query and click Edit Query Statement ¦
Select the Criteria Tab
Click on the Sunshine button to invoke the Criteria Wizard
Select as shown |Click OK | e.g Class attribute = Installed Software |Attribute = ARPDisplay Name
Using an exiting Console Installed client check the display name :

Programs and Features/Add Remove Programs Display Name.

Record the display nameUse the display name captured in Programs and FeaturesClick the Sunshine button (add the Workstation OS restriction)
NB: The patch is the same for the SCSM servers so prevent accidentally deploying to the management server by restricting the query to workstation OS onlyAttribute Class = System Resource | Attribute = Operating System Name and VersionRestrict to Workstation Operating Systems only to avoid updating the Servers (NB though applicable to x64 only; it is best to prevent for all scenarios) Click OKClick NextClick NextNext | Next | Close

Create Advertisement to deploy the update to the collection

SCCM Console |Computer Management | Software Distribution |Advertisements
Provide a name and comments as appropriate |Browse to the package |select the Program | Assign to a collection
Initially assign to the test collection. Change the collection to a live collection once the deployment has been validated
Schedule as necessary
Test
Configure as appropriate and click Next
Configure as appropriate and click Next
Next |Review Summary |Next
Close