SCCM CMPivot Query for Windows 10 English Language Devices | ConfigMgr

0
SCCM CMPivot Query for Windows 10 English Language Devices

Let’s Find devices with Windows 10 English Language(US) installed using ConfigMgr CMPivot Query. I have seen many questions in HTMDForum that we want the SCCM CMPivot pending reboot. In this post, you will learn how to use the SCCM CMPivot query to find out Windows 10 English Language Devices.

You can customize the CMPivot query as per your need and requirement. The following is the main CMPivot entity used is OperatingSystem. The CMPivot entity helps to find out devices with Windows 10 English language versions with the 2004 version.

entity | operator1 | operator2 | ...

The following is the sample CMPivot query that shall help you to understand the entity called OperatingSystem and views which are required to get the report from the SCCM CMPivot report for Windows 10 English Language devices. Hence we have done a tough job for you. Now, you just need to replace the following to get the query working for you.

Launch CMPivot

  • Navigate to device collection against that you want to run the CMPivot query.
  • Select All Systems device collection.

NOTE! – In a production environment with more than many devices, I don’t recommend to use All System collection. Instead, use the collection with a smaller number of devices to try out the query.

  • Right-Click on All Systems collection.
  • Select Start CMPivot.
Launch SCCM CMPivot Query Tool - CMPivot Query for Windows 10 English Language Devices
CMPivot Query for Windows 10 English Language Devices

CMPivot Tool – Run Query

  • CMPivot Query tool got launched.
  • Get familiarized with new query language and CMPivot tool.
  • Copy the queries from the below section.
  • Check out the Run Query button from the ConfigMgr CMPivot tool.
CMPivot Query for Windows 10 English Language Devices
SCCM CMPivot Query for Windows 10 English Language Devices – ConfigMgr

CMPivot Query – Windows 10 English language

You can find the CMPivot values for the below:

English (United States)en-US0x04091033
English (United Kingdom)en-GB0x08092057
Window 10 Language Codes

CMPivot Query to find out Windows 10 US English Language devices.

OperatingSystem | where OSLanguage == 1033

CMPivot Query to find out Windows 10 English Language Device with Windows 10 2004.

OperatingSystem | where OSLanguage == 1033 | where Version == '10.0.19041'
SCCM CMPivot Query for Windows 10 English Language Devices - ConfigMgr
SCCM CMPivot Query for Windows 10 English Language Devices – ConfigMgr

Resources

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.