SCCM Device Collection - Specific Client Version

I recently had to find all computers that do not have the latest client version installed on them, so that I can get them updated to the most current version. To do that I needed a computer collection of all computers with old versions. Here is the query I used:

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.8740.1031"


Source:
https://social.technet.microsoft.com/Forums/systemcenter/en-US/95dce398-17ac-498e-86dc-0d990691fece/collection-query-for-specific-sccm-client-version-parameters?forum=configmgrgeneral 

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.