filmov
tv
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.
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
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
0:26:19
ConfigMgr CMPivot Walkthrough | SCCM CMPivot Queries
0:33:25
Using CMPivot in SCCM for Real-Time Data and Taking Real-Time Action Using Scripts
0:20:31
SCCM Tutorial 42- How to use CM Pivot in MECM
0:05:47
SCCM CMPivot Overview Launch Troubleshoot Run Query What is CMPivot CMPilot Reports Build CMPivot
0:04:01
SCCM CMPivot Tool Features Review - New Video https://www.youtube.com/watch?v=omiLBdIOI-w
0:04:38
Find Windows 11 Versions using SCCM | SQL Query | CMPivot Query
0:03:58
20703-1B Demo6 Using CMPivot for Data Analysis
0:13:55
Unleashing the Power of CMPivot: Finding Installed Software Made Easy
0:20:10
Windows 11 Security Audits using SCCM CMPivot | Who created Local Account | Reset Password Event IDs
0:10:30
Custom Queries in SCCM
0:56:45
Microsoft System Center Configuration Manager Architecture | Global Knowledge
0:07:32
Simplest Trick to Convert WQL to SQL using SCCM | ConfigMgr
0:00:35
CMPivot in Microsoft Endpoint Manager admin center
0:01:00
How To Resolve #SCCM/#MECM Only two Client Agent Action Issues On #Workgroup Clients
0:05:51
SCCM - How to Find What Software is Installed on a Device
0:07:59
What is New in SCCM 1810 ? SCCM 1810 Improvements and New Features - App Repair - HA for CAS
0:13:37
MECM Day 06 - Query Rule Lab
0:06:14
Day 46 Overview of CMPivot
0:54:46
Microsoft SCCM | Microsoft System Center Configuration Manager Architecture
0:03:58
SCCM 1802 | Configure Phased Deployments!
0:08:07
How to Make SCCM Documentation with Automatic Script - How to document SCCM Settings...
0:05:11
fatstacks BI for SCCM
0:25:15
SharpSCCM 2.0: Abusing Microsoft’s C2 Framework (Black Hat USA 2023 Booth Talk)
0:35:45
#SCCM #SCCM Free Tutorials SCCM Hardware Inventory deep dive
Комментарии