ConfigMgr Queries and Collections for Windows 10 Versions

  • [アーティクル]

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. Smile 

"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. https://technet.microsoft.com/en-us/windows/release-info.aspx

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. Queries-And-Collections

Disclaimer: The information on this site is provided "AS IS" with no warranties, confers no rights, and is not supported by the authors or Microsoft Corporation. Use of included script samples are subject to the terms specified in theTerms of Use.

Comments

  • Anonymous
    October 20, 2017
    As written, these queries also include Windows Server 2016 in their output. I would suggest either updating them to only include Windows 10 systems or noting that they include 2016 servers as well.
  • Anonymous
    February 05, 2018
    Really appreciate this. Works flawlessly when imported into our SCCM.