Assets without McAfee

[joen0s]

Hey all,

i have the following question on how i can make a report that will give me all my assets that do not have "McAfee VirusScan Enterprise" installed.

i can get it to work with showing the ones that have it installed but i want to see the ones that dont.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Username,
tblSoftwareUni.softwareName
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName = 'McAfee VirusScan Enterprise' And
tblAssetCustom.State = 1

this is what i have to show all my assets with the software installed. but how do i tell it to "IS NOT" because i cant get that to work.

hope to hear from you guys!

Thanks in advance

[Daniel_B · Accepted solution]

This page describes how to create a report on computers not having a specific software installed.

Note that Lansweeper uses two ways of scanning anti-virus information: List of installed software and additional status information scanned from WMI. You can find details in this KB article.