SCCM 2012 R2 CU 4 Installation- Step-by-Step

To upgrade to SCCM 2012 R2 CU4, you must have at least 5.00.7958.1000 version.

Please download it from Microsoft https://support.microsoft.com/kb/3026739

It’s a hotfix so need to be requested. An email will be sent from microsoft with download link.

This link has details about bugs/fixes.

Run downloaded file  CM12-R2CU4-KB3026739-X64-ENU.exe on Standalone primary server.

Click Next

Accept the license term

Perquisites check should be all successful.

Check this and click next

Select Update DB and click Next

Check all and Click Next

Click Next

Click Next

Click Next

Click Install

Click Next

Click Finish

Please Check log here C:\Windows\Temp\CM12-R2CU4-KB3026739-X64-ENU.log

Client version should be 5.00.7958.1501 

Check the version to verify the install.

 Packages will be available here for deployment to Clients.

Verify registry on primary server: --- HKLM\Software\Microsoft\SMS\Setup\ key. 

SCCM 2012 Dynamic Collection Query for Computers by Model Number

Here is WQL for a hardware models...

select distinct SMS_G_System_COMPUTER_SYSTEM.Name, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_R_System.LastLogonUserName from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXXX" or SMS_G_System_COMPUTER_SYSTEM.Model like "XXXXXXX"