SCCM Query for Devices Running Windows 10

SCCM Query for Devices Running Windows 10

All Devices Running Windows 10

select SMS_R_System.Name,
        SMS_G_System_OPERATING_SYSTEM.Name,
        SMS_G_System_OPERATING_SYSTEM.BuildNumber
from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM
on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_OPERATING_SYSTEM.Name like "%Windows 10%"
order by SMS_R_System.Name

All Devices Running v1703 (Creator’s Update)

select SMS_R_System.Name,
        SMS_G_System_OPERATING_SYSTEM.Name,
        SMS_G_System_OPERATING_SYSTEM.BuildNumber
from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM
on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_OPERATING_SYSTEM.Name like "%Windows 10%"
and SMS_G_System_OPERATING_SYSTEM.BuildNumber = "15063"
order by SMS_R_System.Name

All Devices Running v1607 (Anniversary Update)

select SMS_R_System.Name,
        SMS_G_System_OPERATING_SYSTEM.Name,
        SMS_G_System_OPERATING_SYSTEM.BuildNumber
from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM
on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_OPERATING_SYSTEM.Name like "%Windows 10%"
and SMS_G_System_OPERATING_SYSTEM.BuildNumber = "14393"
order by SMS_R_System.Name

All Devices Running v1511 (November Update)

select SMS_R_System.Name,
        SMS_G_System_OPERATING_SYSTEM.Name,
        SMS_G_System_OPERATING_SYSTEM.BuildNumber
from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM
on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_OPERATING_SYSTEM.Name like "%Windows 10%"
and SMS_G_System_OPERATING_SYSTEM.BuildNumber = "10586"
order by SMS_R_System.Name

Not Sure How to Create SCCM Queries?

1.) Open the Config Manager Console and view the Monitoring section.

2.) Click on Queries in the sidebar menu and select Create Query

Creating A Query 01

3.) Enter the name of the query and select Edit Query Statement….

Creating A Query 02

4.) Click on Show Query Langauge to paste in your WQL, or use the Query Design interface to create the query.

Creating A Query 03

5.) In the Create Query Wizard select Next, Next and Close. The Wizard will let you know if your WQL syntax is incorrect.

6.) That’s it - you should be able to run your query now! :fire:

Adventure Time
Jacob Boykin's Picture

About Jacob Boykin

Jacob is a system administrator, web developer and musician based in Melbourne, Florida.

Melbourne, Florida https://jacobboykin.com

Comments