CMPivot hanging!!!

Duchemin, Dominique 1,806 Reputation points
2023-09-07T22:52:00.99+00:00

Hello,

I have a CM Pivot query looking for Real Time Protection Disabled for Windows Defender:

Registry('HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows Defender\real-time protection')
| where Property == 'DisableRealTimeMonitoring'

but it is locked at 4 of 18 clients!!! for hours!!! 2023-09-07_15-52-35 DisableRealTimeMonitoring hanging.jpg

Why ? where should I look for issues?

Thanks,

Dom

Microsoft Configuration Manager Deployment
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Deployment: The process of delivering, assembling, and maintaining a particular version of a software system at a site.
760 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. AllenLiu-MSFT 32,111 Reputation points Microsoft Vendor
    2023-09-08T02:33:31.92+00:00

    Hi, @Duchemin, Dominique

    Thank you for posting in Microsoft Q&A forum.

    This could be due to a variety of reasons such as network connectivity issues, client machine issues, or even security software blocking the query.

    One thing you can try is to check the status of the clients that are not responding to the query. You can also try to run the query again and hold down the Ctrl key while clicking Run to rerun the query on the clients.

    If the issue persists, you may want to check if any security software is blocking the query. As mentioned in the documentation, some security software may block scripts running from c:\windows\ccm\scriptstore which can prevent successful execution of CMPivot queries. It is recommended to exclude %windir%\CCM\ScriptStore so that the anti-malware software permits those features to run without interference.

    The reference:

    https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/cmpivot#:~:text=aren%27t%20in%20compliance.-,Important,-Some%20security%20software


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

    0 comments No comments

  2. Duchemin, Dominique 1,806 Reputation points
    2023-09-08T15:43:23.6933333+00:00

    Thanks @AllenLiu-MSFT

    I will check with the AntiVirus...

    Thanks,
    Dom

    0 comments No comments

  3. Duchemin, Dominique 1,806 Reputation points
    2023-09-08T15:43:44.46+00:00

    Thanks @AllenLiu-MSFT

    I will check with the AntiVirus...

    Thanks,
    Dom