Code to show coputers that have software1name and software2name installed

[Subtitling]

Would someone please show me the Lansweeper code for showing all computers that have software with "ZoneAlarm PRO ANTIVIRUS" and "McAfee Internet Security" in the software title and installed on the same computer? My SQL isn't what it should be! 😞

Many thanks

[Subtitling]

Thank you, that works fine.

[Nick_VDB · Accepted solution]

Please use the report below for the information that you are after. You can add the report to Lansweeper by following the steps found here. If the software names are not correct you can replace them in report.

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
Where tblAssets.AssetID In (Select Top 1000000 tblAssets.AssetID
  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 Like '%ZoneAlarm PRO ANTIVIRUS%') And
  tblAssets.AssetID In (Select Top 1000000 tblAssets.AssetID
  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 Like '%McAfee Internet Security%')
  And tblAssetCustom.State = 1