SCCM Current Branch 1806 is loaded with amazing features. In this post, we will cover the latest addition in the reporting space: CMPivot. SCCM has always been good with reporting and inventory of it’s managed devices but SCCM data is up-to-date at the last time the inventory has been run. SCCM CMPivot allows SCCM administrators to initiate a live query on selected computers on a specific topic. The result of that query can then be used to mitigate and fix potential issues.

How many time were you asked “what is the current state as of NOW?” well, you’ll finally be able to answer appropriately with SCCM CMPivot.

In this post, we will covert how to use CMPivot to create a basic query and how to use the result of this query.

SCCM CMPivot Prerequisites

• SCCM must be Current Branch 1806 or higher
• SCCM clients must be running 1806 or higher
• Powershell  v5.0 on target clients
  • This is not 100% mandatory as only the following entities require PowerShell v5.0 to run
    • Administrators
    • Connection
    • IPConfig
    • SMBConfig

How to use SCCM CMPivot

The first step is to select a computer collection to run CMPivot against those computers. We will select our All Server Clients collection. In our example, we will query the computer to have information about their Operating System version.

• Select the collection and from the Ribbon, select Start CMPivot

• The CMPivot window show up to configure the query

• The Home tab provides details on how to create queries
• Select the Query tab

• Select one of the available entities to target, Right click on it and select Insert

• The entities to query on is then added to the query

• Running the query as is will return all information about that entities

• To refine the query, add the pipe character |, this will provide the list of operators to be added after the |

• Then CMPivot will propose entities

• Here we addVersion to be like ’10.%’

• CMPivot will automatically correct it to look that way, once we Run the query.

• This provides a subset of computers

• Now that we have a list of computer, the following actions can be performed :
  • Create a collection based on those computers
  • Pivot to, which allows seeing other entities in CMPivot for a specific computer
  • Run Script, this can be run on multiple computers at a time
  • Remote Control a specific computer
  • Open the Resource Explorer for a specific computer

• The Pivot to is a quick access to other Entities for a specific computer.

This feature is brand new and we have yet to found a real-world scenario that requires this. We’ll update this post when we have some interesting queries.

Do you have a great query that could help other SCCM administrators out there? Share it in the comments below!

More details and examples available on Microsoft Docs

[ratings]