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