_ap_ufes{"success":true,"siteUrl":"eskonr.com","urls":{"Home":"http://eskonr.com","Category":"http://eskonr.com/category/net-framework-4-0/","Archive":"http://eskonr.com/2014/12/","Post":"http://eskonr.com/2014/12/configmgr-2012-query-how-to-get-list-of-applications-that-requires-approval/","Page":"http://eskonr.com/orchestrator-scorch-guides/","Wpcf7_contact_form":"http://eskonr.com/?post_type=wpcf7_contact_form&p=1610","Wpdmpro":"http://eskonr.com/download/hypervhostinformation/","Safecss":"http://eskonr.com/?safecss=safecss"}}_ap_ufee ESwar KONeti » SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients

ESwar KONeti

All about Configmgr and its Connected Objects….

  • About Author
      View eswar koneti's LinkedIn profile
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 260 other subscribers

  • Archives

  • Meta

  • #Configmgr Tweets

  • Copyright!

    All the blog posts in this website are owned by Eswar Koneti and may not be reused in any mode without prior approval of Eswar Koneti. You may quote one paragraph from the blog posts if you link to the original blog post.
    Happy Reading!

  • Like us on FaceBook

  • Awards


SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients

Posted by Eswar Koneti on September 25th, 2013

Few Days ago,Microsoft released Cumulative Update 3 (supersedes Cumulative update 2 ) for Configuration Manager 2012 SP1 which has around 18 fixes related OSD,Powershell,Software Distribution etc.

More about the hotfix and download refer http://support.microsoft.com/kb/2882125

Installation of Cumulative Update 3 on Configurations manager SP1 is straight forward.you would need to follow the steps,next,next ,done.

This Cumulative Update contains updates for CAS,Primary site(both Stand alone,Hierarchy),Secondary Site,SMS Provider,Configmgr Console and Configmgr Client.

I have updated my Lab with Cumulative Update 3 today,saw couple of packages gets created with this update.

Note:Close the Configuration Manager Administrator Console before you install this update.

After the installation is completed,you will see 4 Packages created 1) Console 2) server (Primary and Secondary) 3) X86 Client and 4 ) X64 Clients

Note: Configuration manager 2012 SP1 CU3 Client version : 5.00.7804.1400.

image thumb14 SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients

Packages resides on HotFix Folder from your Configmgr Drive.image thumb8 SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients

Distribute these packages to selected distribution points,monitor the status(distmgr.log,sender.log and pkgxfermgr.log) .

Note :This patch will not install automatically on the Configmr clients, You should distribute the patch (msp file) to all existing clients in the environment.

We will now create collection for each update and then deploy the patch.

SP1 CU3-Console Update:

Select SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft System Center 2012 Configuration Manager Console"
and SMS_R_System.Client = "1" and SMS_R_System.Active = "1"

SP1 CU3-Server Update (all Pri and Sec) :

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,
SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System
where SMS_R_System.SystemRoles = "SMS Component Server"


 

SP1 CU3 –X86 Client Update:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId

inner join SMS_G_System_SMS_ADVANCED_CLIENT_STATE on SMS_G_System_SMS_ADVANCED_CLIENT_STATE.ResourceId = SMS_R_System.ResourceId
where SMS_R_System.Client = "1" and SMS_G_System_SYSTEM.SystemType = "X86-based PC"
and SMS_R_System.Active = "1" and SMS_G_System_SMS_ADVANCED_CLIENT_STATE.DisplayName = "CCM Framework"
and SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Version != "5.00.7804.1400"

SP1 CU3 –X64 Client Update:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId
inner join SMS_G_System_SMS_ADVANCED_CLIENT_STATE on SMS_G_System_SMS_ADVANCED_CLIENT_STATE.ResourceId = SMS_R_System.ResourceId
where SMS_R_System.Client = "1" and SMS_G_System_SYSTEM.SystemType = "X64-based PC"
and SMS_R_System.Active = "1" and SMS_G_System_SMS_ADVANCED_CLIENT_STATE.DisplayName = "CCM Framework"
and SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Version != "5.00.7804.1400"

After you do this,collections will populate computers.

 

image thumb9 SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients

Right click on package, deploy to respective collection with required schedule.

image thumb10 SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients

Go to the client,do machine policy if you want this to happen quick else wait for the default machine policy retrieval.

Before the CU3 Patch installation,Client Version: 5.00.7804.1000 (SP1)

image thumb11 SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients

After the Patch Installation:

image thumb12 SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients Client is Upgraded to CU3 with version 5.00.7804.1400

image thumb13 SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients

15 Responses to “SCCM Configmgr 2012 SP1 CU3 Installation,Collections ,Upgrade Clients”

  1. bandara Says:

    Hi Your blogs are good, I like it.
    I need to advice from you.
    My system center configuration manager just 2013.
    What s the upgrade procedure for SCCM 2012 SP1 CU 3
    And hope SCCM 2012 R2 is not good for production use.

    Thanks

  2. Scott Says:

    Great Post! However, the SQL query for the Console Update is missing "select" at the beginning of the query.

  3. Eswar Koneti Says:

    thanks for the correction.updated the blog

  4. Eswar Koneti Says:

    there is no special instructions to upgrade from CM12 SP1 to CU3.close the console and start installing the CU3 hotfix.just follow the instructions step by step what it takes you.

  5. bandara Says:

    My Question here can I directly upgrade it to SCCM 2012 to SCCM 2012SP1 CU3

  6. Eswar Koneti Says:

    nope,you must have CM12 SP1 before you install CU3 hotfix.More info http://support.microsoft.com/kb/2882125

  7. Joe Heaton Says:

    I copied and pasted the first query, for the console update, and when I clicked ok after pasting in the Query Statement, I got an error:

    This query has a syntax error. Are you sure you want to save it?

    Did I do something wrong?

    My system is at SP1, with no CU installed.

  8. Eswar Koneti Says:

    check the quotes ,they will be replaced to fancy by browser.try to replace ' and " using the quotes and try.

  9. Joe Heaton Says:

    Thanks, the quotes were exactly the problem.

    Another question, when you push the new, updated client, will that also update the SCEP that's installed, or, if none installed, will it install the new SCEP? I'm trying to get some Server 2012 R2 boxes protected.

  10. Eswar Koneti Says:

    Yes,I hope so,I havent over looked into it but it also upgrades to the new version.

  11. babu Says:

    hi eswar ,

    I am new to SCCM 2012 group and i have knowledge on sccm2007. i want to discuss some issue what i have with SCCM2012 installtion. The issue is my machine got rebooted while installing sccm 2012 SP1.i have already installed all the prerequisites for SCCM2012.i am installing sccm2012 on Hyper-V machine.

    Please see my system configuration below:

    DomainController(2008R2 server) : 512MB RAM, AD things and DNS ,DHCP has installed on it.

    System center server(2008R2) : 1028MB RAM , Sql 2008 server installed on it.

    i tried to install it many times but still i got the same issue.
    Could you please help me with this ?

  12. Eswar Koneti Says:

    what issue are you getting ? you never said the error message.what does the configmgrsetup.log syas ?

  13. babu Says:

    I dont see any error in configmgrsetup.log but logs have been stopped after rebooting.

  14. Dean Says:

    This is a great help! Thank you, I am always nervous about using specific versions in my queries. I prefer to use a query with a minimum version and a "less than" or "greater than" condition. but multi-part versions can cause some real pain with that as well! Just something that has burned me in the past, and something to watch out for as the product moves ahead! Thanks again!

  15. Eswar Koneti Says:

    I have used the same in collection quiries.. Min version i.e R2 client and lessthan CU3 version to get all R2 clients without cu3 patch.

Leave a Reply

*