SCCM CMPivot Query to find 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 discover Windows 10 English Language Devices. You can customize the CMPivot query according to your needs and requirements.

The primary CMPivot entity used is the Operating System. The CMPivot entity helps to find devices with Windows 10 English language versions and the 2004 version.

entity | operator1 | operator2 | ...

The following is the sample CMPivot query that will help you understand the OperatingSystem entity and the views required to get the report from the SCCM CMPivot report for Windows 10 English Language devices. Hence, we have done a formidable job for you.

Patch My PC
Index
Launch CMPivot
CMPivot Tool – Run Query
CMPivot Query – Windows 10 English language
SCCM CMPivot Query to find Windows 10 English Language Devices – Table 1

Launch CMPivot

To execute CMPivot, launch the tool, navigate to the specific device collection where you intend to run the CMPivot query and select the All Systems device collection.

NOTE! – I don’t recommend using the All System collection in a production environment with more than a few devices. Instead, use the collection with fewer devices to try out the query.

Right-click on the All Systems collection.

  • Select Start CMPivot.
SCCM CMPivot Query to find Windows 10 English Language Devices - Fig.1
SCCM CMPivot Query to find Windows 10 English Language Devices – Fig.1

CMPivot Tool – Run Query

The CMPivot Query tool has been launched, allowing you to familiarize yourself with the new query language and tool functionality. Below, you can copy the queries and try out the Run Query button in the ConfigMgr CMPivot tool.

Adaptiva
  • Check out the Run Query button from the ConfigMgr CMPivot tool.
SCCM CMPivot Query to find Windows 10 English Language Devices - Fig.2
SCCM CMPivot Query to find Windows 10 English Language Devices – Fig.2

CMPivot Query – Windows 10 English language

Here are the settings included in the following tables:

1. Language/region: This is the name of the language in the user interface (UI), and all Windows language packs are available on the Windows Server.

2. Language/region tag: This language identifier is used with the DISM tool or in an unattended answer file. It is based on the language tagging conventions of RFC 3066.

3. Language/region ID: This ID is the language identifier in hexadecimal, used with the keyboard identifier for input methods in DISM.

4. Language/region decimal identifier: This number shows the language, and it’s used in Oobe.xml.

You can find the CMPivot values below:

    Language/regionLanguage/region tagLanguage/region IDLanguage/region decimal ID
    English (United States)en-US0x04091033
    English (United Kingdom)en-GB0x08092057
    SCCM CMPivot Query to find Windows 10 English Language Devices – Table 2

    CMPivot Query is used to find Windows 10 US English Language devices.

    OperatingSystem | where OSLanguage == 1033

    CMPivot Query to discover Windows 10 English Language Device with Windows 10 2004.

    OperatingSystem | where OSLanguage == 1033 | where Version == '10.0.19041'
    SCCM CMPivot Query to find Windows 10 English Language Devices - Fig.3
    SCCM CMPivot Query to find Windows 10 English Language Devices – Fig.3

    Resources

    We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

    Author

    Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.

    Leave a Comment

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