ConfigMgr: CMPivot in all its glory

-

CMPivot was first introduced in ConfigMgr CB 1806 and since its release, ConfigMgr as a product has became a little more real time. Especially when it comes to pulling deployment or compliance status. I must admit that I didn’t use CMPivot much earlier, but ever since remote working became the new normal, I started using CMPivot queries regularly and the more I used it, the more I found myself appreciating the efforts of the product team behind implementing this great feature.


If you manage your end user devices over the internet using Cloud Management Gateway (CMG), you would understand the pain of not being able to perform any remote administration tasks like checking the logs, or taking remote control etc. This is where CMPivot query can be really helpful.


According to Microsoft:-


CMPivot allows you to quickly assess the state of devices in your environment and take necessary actions. When you enter a query, CMPivot will run a query in real - time on all currently connected devices in the selected collection. The data returned can then be filtered, grouped, and refined to answer business questions, troubleshoot issues in your environment, or respond to security threats. CMPivot sends queries to clients using the Configuration Manager "fast channel". Clients return results via the similarly quick state message system. State messages are temporarily stored in the database.


Now the fun and interesting part


To run the CMPivot queries,

1. Connect to Configuration Manager Console and navigate to Assets & Compliance.

2. Select the device collection and either click the CMPivot from the menu ribbon or right click on the collection and select from there.

 



3. The CMPivot Window will show up to enter the query.

4. Select the query tab and Manually enter the query string.


Here are some examples that you can use.


For checking the installation status of an update –



For checking the uptime of the devices – 



For monitoring the status of IPU task sequence deployment over the internet -



For capturing the OS build number real time over the internet -



5. The pane on the left lists the Entities that are available on clients. Some entities rely upon WMI while others use PowerShell to get data from clients. You can right-click an entity for the following actions:

Insert: Add the entity to the query at the current cursor position. The query doesn't automatically run. This action is the default when you double-click an entity. Use this action when building a query.

Query all: Run a query for this entity including all properties. Use this action to quickly query for a single entity.

Query by device: Run a query for this entity and group the results. 

CMPivot uses subset of Kusto Query Language (KQL) and you can read all about it over here.

Conclusion

There are lot of Entities in CMPivot to work with and Microsoft are adding new regularly. There can be many other real time application of the queries, but for now I hope the above helps. I will update the post if I come across any more useful queries.


Until next time..

Comments

Post a Comment

Popular posts from this blog

How to force escrowing of BitLocker recovery keys using Intune

-
Image
Every now and then it so happens that BitLocker recovery keys do not escrow in AAD. The usual culprits are incorrect BitLocker policies and\or the device hardware configuration failing to meet the minimum requirements. The other scenario and something I recently experienced is when everything is setup right and still the recovery key doesn’t escrow in AAD. As I understand, this can happen if the escrow process got interrupted the first time due to network or local devices related issues and the process could not resume. To circumvent this issue, one can simply push a PowerShell script to the devices to force the escrow of the recovery keys to AAD. Here is a script to do so. try{ $BitlockerVol = Get-BitLockerVolume -MountPoint $env:SystemDrive         $KPID=""         foreach($KP in $BitlockerVol.KeyProtector){             if($KP.KeyProtectorType -eq "RecoveryPassword"){                 $KPID=$KP.KeyProtectorId                 break;             }         }        $o
Read more

Intune: Configure Printers for Non-Administrative Users

-
Image
Configuring printers for end users or giving them the ability to do it themselves is a normal requirement for organizations. Now if your users are Administrators, then the configuration can be straight forward, but in case of Non-Administrators there are additional steps required as Non-Administrators will not be able to add a driver in the driver store despite being able to install a printer. In this blog, I will cover the steps that I took to address this requirement using Intune. The setup involves 2 steps -  1. Setup registries. 2. Install the driver and configure the printer Setting up registries – The registries that need to be configured are actually part of a GPO setting – Allow non-administrators to install drivers for these device setup classes It can be found under: Computer Configuration -> Policies -> Administrative Templates -> System -> Driver Installation I used a Powershell script to set the values and wrapped it in a Win32 application. $Path1
Read more

Intune: UAC Elevation Prompt Behavior for Standard Users

-
Image
Implementing and maintaining a good security posture is an integral part of overall IT security governance for most organizations now. While you want to harden the security of infrastructure and give least number of privileges to your end users, sometimes you may need to cut back on the restrictions to ensure a good user experience and an effective IT support process. Recently, I had a requirement where the customer wanted to ease the restriction on the end user devices to make the helpdesk support process more efficient. This involved easing the UAC level access for the Standard users and if you are managing your devices using Intune, then this blog may just help you. Let us see what all is involved and some of the ways that you can use to implement this easily. Policy CSP – LocalPoliciesSecurityOptions LocalPoliciesSecurityOptions has many CSP settings and if you are managing these settings at an individual level, then the CSP that we need to concern ourselves with here is U
Read more