CMPivot hanging!!!

Question

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

Answer 1

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".

Answer 2

Thanks @AllenLiu-MSFT

I will check with the AntiVirus...

Thanks,
Dom

Answer 3

Thanks @AllenLiu-MSFT

I will check with the AntiVirus...

Thanks,
Dom