SCCM WQL Query – All Windows 10 Installs

Last updated on March 30th, 2023 at 06:04 pm

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 well.

Feedback

If you have any questions about this query, please feel free to leave us a message below and we will get back to you when we can.