Enjoy Sharing

Creating a Collection of Computers with Old Configuration Manager Console Version

You might have upgraded your Configuration Manager environment to the latest service pack 1 of 2012 R2 and suddenly realise your console installed on your local computer (not the Site Server) has stopped working and couldn’t connect to your Site Server. You could manually upgrade all your consoles by running the install or you could get ConfigMgr to do that for you. To do that you need a collection of computers that have the older version of the console. Just go ahead and use the collection query statement below to do that. The below queries for the 2012 R2 (non-SP1) version of the console.

Note that if you are trying to query the 2012 SP1 version, it is called “Microsoft System Center 2012 Configuration Manager Console” without the quotes instead of what’s used below. The names will defer slightly from one version to another.


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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = ‘System Center 2012 R2 Configuration Manager Console’





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s