SCCM – Query for Windows 10 by Build Numbers

email me

In SCCM Console > Monitoring > Queries, Copy/paste this as a new query.

select distinct SMS_R_System.Active,
SMS_R_System.NetbiosName,
SMS_G_System_OPERATING_SYSTEM.InstallDate,
SMS_R_System.ADSiteName,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_G_System_OPERATING_SYSTEM.BuildNumber,
SMS_G_System_CH_ClientSummary.LastMPServerName from  SMS_R_System
inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID
= SMS_R_System.ResourceId
inner join SMS_G_System_CH_ClientSummary on SMS_G_System_CH_ClientSummary.ResourceID
= SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.BuildNumber like "%16299%"
or SMS_G_System_OPERATING_SYSTEM.BuildNumber like "%17134%"
or SMS_G_System_OPERATING_SYSTEM.BuildNumber like "%15063%"
or SMS_G_System_OPERATING_SYSTEM.BuildNumber like "%14393%"
or SMS_G_System_OPERATING_SYSTEM.BuildNumber like "%10240%"
or SMS_G_System_OPERATING_SYSTEM.BuildNumber like "%10586%"