Windows 10 is out for a while now. Not all have used the modern OS in Configuration Manager yet. Newer and better versions of windows 10 are released every six months.
All versions available can be checked on this official page: https://technet.microsoft.com/en-us/windows/release-info.aspx
Windows 10 build editions query
So, to generate a simple overview of the managed systems I have created a query you can use. In the the ConfigMgr console go to Monitoring -> Queries.
Very usefull information can be displayed here [Click to view] like the build numbers, Netbios name, workgroup name, architecture and the servicing channel.
1 |
select SMS_R_System.Name, SMS_R_System.Client, SMS_G_System_FIRMWARE.UEFI, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_OPERATING_SYSTEM.BuildNumber, SMS_G_System_OPERATING_SYSTEM.Version, SMS_G_System_OPERATING_SYSTEM.Caption, SMS_G_System_OPERATING_SYSTEM.OSLanguage, SMS_R_System.OSBranch, SMS_G_System_COMPUTER_SYSTEM.SystemType, SMS_R_System.SMSUniqueIdentifier 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId left join SMS_G_System_FIRMWARE on SMS_G_System_FIRMWARE.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 10.0" or SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 10.0 (Tablet Edition)" |
So the different versions have their own version numbers, like 1511,1703,1709 but I don’t believe they can be showed or queried here?..
Another usefull property is if the system is using BIOS or UEFI. This can be added since the release SCCM 1701/1702 using the SMS_Firmware Class.
W10 Collections
It’s not difficult to create Collections using these query rules. These can be used in different scenario’s. This Example can be extended..
All Windows 10 Clients
1 |
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 = "Microsoft Windows NT Workstation 10.0" or SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 10.0 (Tablet Edition)" |
All Windows 10 v1709 Build 16299
1 |
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_G_System_OPERATING_SYSTEM.BuildNumber = "16299" |
Leave A Comment