Report to show which servers a piece of software is NOT installed on

You can define a report containing custom table and you can use "Custom SWQL" query to pull this information.

I'm sharing an example query below which lists all servers that are monitored for "Asset Inventory" and they don't have "Google Chrome" software installed. You can tune this query for the software name that you would like to report:

SELECT NodeID
, ai.Node.Caption as [Server Name]
, ai.Node.MachineType as [Operating System]
, PollingDescriptionName as [Polling Mechanism]
, LastPollDateTime as [Last Poll Time]
FROM Orion.AssetInventory.Polling ai
WHERE Enabled='True'
AND NodeID not in 
(
    SELECT NodeID
    FROM Orion.AssetInventory.Polling p
    WHERE p.Software.Name like '%Google Chrome%'
)
ORDER BY ai.Node.Caption

Came up with something similar, but WISH I HAD READ THIS FIRST. Thank you for posting as this is cleaner than my swql. 

Came up with something similar, but WISH I HAD READ THIS FIRST. Thank you for posting as this is cleaner than my swql.