Software Report help

[matthew1g]

I need to run a custom report that will list any computers that do not have software X or software Y installed. If the computer has either installed it should not show up on the list. I have a report to show 1 piece of missing software but I have not been able to figure out how to search for 2. Any help would be appreciated!

current report:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName As AssetName1,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Symantec Encryption Desktop%')

[Hemoco · Accepted solution]

Replace this...

Where tblSoftwareUni.softwareName Like 'Symantec Encryption Desktop%'

... with this:

Where tblSoftwareUni.softwareName Like 'Symantec Encryption Desktop%' or Like '%Name of other software package%'

We would also recommend adding the below criterion to the Criteria column for the tsysAssetTypes.AssetTypename expression, so only Windows computers will be included in your report output.

= 'Windows'