SCCM WQL Query – All Windows 10 Installs

WQL Query: Collection of All Windows 10 Devices

If you’re building a Configuration Manager device collection that should contain every machine currently running Windows 10 — useful as a baseline collection to build update rings, application deployments, or upgrade-readiness collections from — this WQL query membership rule does the job:

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.0%"

Add this as a query-based membership rule on a new device collection, and Configuration Manager will keep it up to date automatically on its normal collection evaluation schedule, adding and removing devices as their reported OS changes. Two things worth knowing: this matches on the OS name/version as reported by hardware inventory, so a device needs at least one successful inventory cycle before it’ll show up in the collection; and because the pattern only filters on “Workstation 10.0”, it includes all Windows 10 feature updates and builds equally — if you need to split it down further by a specific build number, add an additional and SMS_R_SYSTEM.Build like "..." clause.

Why This Collection Still Matters Post-EOL (Updated for 2026)

With Windows 10 having reached the end of free support on 14 October 2025, a collection of every still-running Windows 10 device is now most useful as a decommission/upgrade-tracking tool rather than an update-ring baseline: cross-reference it against your ESU enrollment records to confirm every machine still on Windows 10 is either covered (free via 1,000 Microsoft Rewards points or paid, through 12 October 2027) or actively scheduled for a Windows 11 upgrade. A machine showing up here with neither should be treated as a priority.

Resources

• WQL
• query
• Microsoft