a simple report for 2 non existing Software

[IT-riha]

I would like to have a report telling me on which computers neither the one nor the other software is installed.

Thx

[RCorbeil]

Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblComputerSystem On tblComputerSystem.AssetID = tblAssets.AssetID
Where
  tblAssetCustom.State = 1                -- active
  AND tblAssets.AssetType = -1            -- Windows machines
  AND tblComputerSystem.Domainrole <= 1   -- workstations
  AND Not Exists (Select tblSoftware.AssetID
              From tblSoftware
                Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
              Where tblSoftware.AssetID = tblAssets.AssetID
                And tblSoftwareUni.softwareName = 'software_1_name'
                And tblSoftware.softwareVersion = 'software_1_version')
  AND Not Exists (Select tblSoftware.AssetID
              From tblSoftware
                Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
              Where tblSoftware.AssetID = tblAssets.AssetID
                And tblSoftwareUni.softwareName = 'software_2_name'
                And tblSoftware.softwareVersion = 'software_2_version')