Creating a Collection of Computers with Old Clients Agent Version
So you might wanna do this when you want to upgrade older versions of the ConfigMgr agent to a later version. This scenario is common in a Service Pack upgrade or even a Cumulative Upgrade. In my case, I’m trying to upgrade all my clients to ConfigMgr 2012 R2 Service Pack 1 and therefore in my query I’m looking for all client version that are not equal to the version I’m planning to deploy. You might want to do this just to keep track of your client upgrades.
So if you’re looking at gathering clients of another version, go ahead and change the ClientVersion. You can find out the client version number from the Configuration Manager icon in the Control Panel. So to create that collection, use my exported collection query statement below.
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.ClientVersion != ‘5.00.8239.1000’