CMPivot InstallSoftware - Find devices where software is missing

Scott Craig 21 Reputation points
2021-04-29T15:25:26.437+00:00

Hello,

I know that the following with show all devices that has a product installed.
InstalledSoftware | where SoftwareCode == '{C1198F10-5A16-4E9A-98B4-7554CC262ACC}'

This shows every product except the product listed.
InstalledSoftware | where SoftwareCode != '{C1198F10-5A16-4E9A-98B4-7554CC262ACC}'

Is there a way to display devices missing the product {C1198F10-5A16-4E9A-98B4-7554CC262ACC}

Thank you

Microsoft Configuration Manager
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HanyunZhu-MSFT 1,826 Reputation points
    2021-04-30T08:06:42.65+00:00

    @Scott Craig

    After doing the lab test, the following script may meet your needs, it can list the devices that do not install the specified product:
    InstalledSoftware | where SoftwareCode != '{C1198F10-5A16-4E9A-98B4-7554CC262ACC}' | summarize dcount(Device) by Device
    (You can change the software code if you need.)

    Hope it can help you.


    If the response is helpful, please click "Accept Answer"and upvote it.
    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.