Collection query for All Windows 10 version 1709

This is a quick post about a query you can use to find All Windows 10 version 1709, here’s the query !

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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.OSBranch != 2 and (SMS_R_System.OperatingSystemNameandVersion = ‘Microsoft Windows NT Workstation 10.0’ or SMS_R_System.OperatingSystemNameandVersion = ‘Microsoft Windows NT Workstation 10.0 (Tablet Edition)’) and SMS_G_System_OPERATING_SYSTEM.BuildNumber in (‘16299’)

cheers !

niall

This entry was posted in 1709, Windows 10. Bookmark the permalink.