CMPivot Query find missing InstalledSoftware

Scott Craig 21 Reputation points

If I query
InstalledSoftware | where SoftwareCode == '{C1198F10-5A16-4E9A-98B4-7554CC262ACC}'

It will list all device that has this Software Code.

If I query
InstalledSoftware | where SoftwareCode != '{C1198F10-5A16-4E9A-98B4-7554CC262ACC}'

It lists all other Installed Software except {C1198F10-5A16-4E9A-98B4-7554CC262ACC}.

Is there a way to display only devices that are missing {C1198F10-5A16-4E9A-98B4-7554CC262ACC}?

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. Amandayou-MSFT 11,046 Reputation points

    Hi @Scott Craig ,

    We could try to use the following query to achieve it:

    | where SoftwareCode != '{C1198F10-5A16-4E9A-98B4-7554CC262ACC}'
    | distinct Device

    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.

3 additional answers

Sort by: Most helpful
  1. Polk, Carl 86 Reputation points

    Yea waiting for inventory to come back for the report to work takes awhile depending on your setttings. In CMPivot you can use a join and bounce it off piece of software you know is on every computer. I used this one to find computers missing certain piece of McAfee. I know all my have config manager but you can whatever company wide piece of software.

    InstalledSoftware | where ProductName like 'configuration Manager Client'
    | join kind=leftouter (InstalledSoftware | where productName like 'McAfee Endpoint Security Threat Prevention')
    | where isnull(ProductName1)
    | project Device

    Hope this helps

    1 person found this answer helpful.

  2. Garth Jones 2,071 Reputation points

    Is there a reason why you are not using the builtin reports for this? You do know this will cause a network load.

    0 comments No comments

  3. Scott Craig 21 Reputation points

    Sorry, I didn't get notified there was responses.

    I haven't found a good report to show me missing installation that wasn't installed through a deployment. The software is preinstalled from another group with a fat image.

    But the answer Amanda has provided worked for me. Thank you Amanda.


    0 comments No comments