CMPivot query

Duchemin, Dominique 2,006 Reputation points
2022-07-15T03:35:17.49+00:00

Hello,

I have this query used by CMPIVOT:

Registry('HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate') | where Property == 'WUServer'

| order by Value

Now I would like a query which will gives me the registry missing this WUServer Property...

Thanks,
Dom

Microsoft Configuration Manager
{count} votes

Accepted answer
  1. AllenLiu-MSFT 42,351 Reputation points Microsoft Vendor
    2022-07-15T07:26:35.727+00:00

    Hi, @Duchemin, Dominique

    Thank you for posting in Microsoft Q&A forum.

    I'm afraid CMpivot can not get the result that missing the WUServer Property, however we can use configuration item and configuration baseline to get the result.
    We can create a CI like below and deploy it with a CB, Don't remediate noncompliant, and we can check the results of the deployment to find the noncompliant list after the client evaluate the CI.
    221015-1.png

    220880-2.png


    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 "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful