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:

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

Detailed Steps:

Extract the CU exe to a directory using an extractor (e.g. 7zip) ridiiks3
In the SCCM Console |Computer Management |Software Distribution |PackagesCreate a New Package kj2es02s
Provide a name and optionally a comment ykxoc4zs
Specify the Source directory for the extracted update files (navigate to the SCSM Patch folder) kt2c12u2
Next vqap0d05
Next 3ngieszm
Next |Next|Next xup51vhc
Close r3izwcwy
Create the Install Program bgc4iaj2
msiexec /p SCSM2010SP1_CU_KB2588492_i386_7.0.6555.128.msp /qn c1tbxijl
Configure as required and click Next nuntmr2v
Change to Whether or not a user is logged on to ensure silent installation is successful sutbrrpt
Configure as required and click Next ytk3rasw
Next lxjtcwcc
Next bcrplf5a
Review summary and click Next 20ltwong
Close jjph2ur4
Add to Distribution Point(s) 5vv12cwu
Next y2yyoesd
Select only standard distribution points (do not select the PXE) ms1ag5io
Close gsyn3tpm

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 ghfoenmn
Click on the database icon to invoke the query based collection Wizard lygjbou4
Provide a name for the query and click Edit Query Statement ¦ t3lgw0ws
Select the Criteria Tab aj5kyxth
Click on the Sunshine button to invoke the Criteria Wizard ryouacuv
Select as shown |Click OK | e.g Class attribute = Installed Software |Attribute = ARPDisplay Name sxuumnrl
Using an exiting Console Installed client check the display name :

Programs and Features/Add Remove Programs Display Name.

Record the display namezgxqyjgwUse the display name captured in Programs and Features1vuqygdzClick 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 only
qx4bvsadAttribute Class = System Resource | Attribute = Operating System Name and VersionnxkjhyftRestrict to Workstation Operating Systems only to avoid updating the Servers (NB though applicable to x64 only; it is best to prevent for all scenarios)wte00gxs x1ctesyoClick OKsljpkjx5Click Nexth1sikjyuClick NextowczzlvlNext | Next | Closemxv4lgca

Create Advertisement to deploy the update to the collection

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