Enjoy Sharing

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’







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