Guide

If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query 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.OperatingSystemNameandVersion like “%Microsoft Windows NT Workstation 10%” You can change the “%Microsoft Windows NT Workstation 10%” to create collections for other operating systems as …

If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this WQL query: More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or if you would like us …

If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then you can use the WQL query 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.8412.1007” Where “5.00.8412.1007” is the latest version number that you are currently using.