Menu
CCMEXEC.COM – Enterprise Mobility
  • Home
  • General
  • Configuration Manager
  • Windows 10
  • Windows 11
  • Intune
  • GitHub
  • About
CCMEXEC.COM – Enterprise Mobility

CMpivot = Configuration Manager goes real-time!

Posted on August 5, 2018August 6, 2018 by Jörgen Nilsson

I have worked with SMS/SCCM for many years now and the last 20 years a common question has been “we need to know which computers have a specific file present now!” or “we need to know which computers that have this software installed and we need to know it now”. We have never been able to fulfil that request because things take time, inventory interval, inboxes with backlogs as a result and so on. It can be done with right-click tools but that requires permissions and access to all computers. CMpivot works through CMG as well and for clients that are connected to the MP! But now in 1806 we can finally do it with CM Pivot, amazing!!

CMPivot which has been in Technical Previews before makes it possible to query computers in real-time using the channel that was developed to support Malware alerts fast instead of sending it together with a client policy check or some other scheduled task in Configuration Manager. So finally, the security guys which I would say that most requests come from can get their answer faster than “tomorrow or later this week”.

CMpivot queries the context that you start it in, so if you start CMpivot from the Ribbon when you have selected the “All Desktop and Servers” collection that is what the scope of the result. What can we more do? We can create Collections based on the result and export the result.

How do I get started? CMpivot uses a subset of the Azure Log Analytics data flow model as shown in the help above. The easiest way to test the power of CMpivot is to simply click on a link in the Home tab and then use that query as a start, adding operators and count to it, it really makes sense after a while. Select in this case CCMlogs, the we get the query to query ccmlog.

Then we can easily add “| “ sign so we can filter the result. Then the UI will help us with what values that are valid.

That way we can easily within a few seconds modify the query to only show all lines which starts with Execute.

What is the next step? I would start looking into my RBAC delegation because more than SCCM admins will want to use this feature with the power it brings.

A simply amazing feature and one of the biggest mindset changes to Configuration Manager for a long long time!

1 thought on “CMpivot = Configuration Manager goes real-time!”

  1. Cherif BENAMMAR says:
    August 6, 2018 at 12:14 am

    this is done partially with console extensions like RECAST tool,

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

My name is Jörgen Nilsson and I work as a Senior Consultant at Onevinn in Malmö, Sweden. This is my blog where I will share tips and stuff for my own and everyone elses use on Enterprise Mobility and Windows related topics.
All code is provided "AS-IS" with no warranties.

Recent Posts

  • Tip when troubleshooting unexpected reboots during Autopilot – event ID 2800
  • New settings in Intune Security Baseline Windows 11 24H2 -2504
  • Managing extensions in Visual Studio Code
  • Reinstall a required Win32app using remediation on demand
  • Administrator protection in Windows 11 – First look
©2025 CCMEXEC.COM – Enterprise Mobility | WordPress Theme by Superb Themes
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT