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’