CMPivot InstallSoftware - Find devices where software is missing

Scott Craig 21 Reputation points


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
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HanyunZhu-MSFT 1,836 Reputation points

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