Using CMPivot in SCCM for Real-Time Data and Taking Real-Time Action Using Scripts

In this #SCCM video guide, we will be reviewing how you can use CMPivot to real-time query devices in SCCM and take action using Scripts.

Blog post 👉 https://setupconfigmgr.com/using-cmpivot-in-sccm-for-real-time-data-and-taking-real-time-action-using-scripts

CMPivot is a new in-console utility that now provides access to real-time state of devices in your environment. It immediately runs a query on all currently connected devices in the target collection and returns the results. Then filter and group this data in the tool. By providing real-time data from online clients, you can more quickly answer business questions, troubleshoot issues, and respond to security incidents. (From MS Docs)
Introduction – (0:00)
A quick overview of CMPivot – (1:35)
CMPivot operators in Kusto – (3:39)
Running CMPivot against a collection – (4:13)
Query InstalledSoftware, Filter to Google Chrome, Add version filter, list in piechart – (5:53)
Query local Administrators – (10:49)
Query 32-bit operating systems – (11:54)
Query running process – (13:06)
Query where SMB1 is enabled – (13:33)
Query AutoStartSoftware where it’s from the user registry, and a specific startup process name – (14:38)
Review pre-built scripts we will use to take action on CMPivot results – (16:06)
Use CMPivot registry query to find where the EnableJavaUpdate registry value = 1 then use a Script to set the EnableJavaUpdate value to 0 – (16:28)
Review the process flow for CMPivot queries and scripts – (19:10)
Query where the Google Homepage RegValue != to an expected homepage value and use a script to set the Google Homepage to the expected value – (22:23)
Query all Java 8 Installations, exclude (64-bit) Java 8 installations, run scripts to uninstall all Java 8 (32-bit installations) – (29:44)
#ConfigMgr #PatchMyPC

Видео Using CMPivot in SCCM for Real-Time Data and Taking Real-Time Action Using Scripts канала Patch My PC