With the recent release of Windows 10 RS3 aka 1709 aka build 16299 i thought it was a good time to post some queries and collections for each Windows 10 version released so far. Additionally i also included Queries for each OS released as far back as XP that i happened to have access to at the time of this post.
The Query itself is very simple and i like to create queries for reuse later on with collections etc. so my admins can easily reference these for reuse without unknowingly deploying to the wrong systems… “I kinda just don't trust anyone” its part of 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 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\""
For a full comprehensive list of Windows 10 Build history see the link below.
If you would like to skip all the manual stuff you can go ahead and grab the mof files for import for collections and queries below and be on your way.