Report for Assets that have both of two Applications Installed

[lmiller]

Hello All,

I am trying to create a report that will Give me a list of all computers that have both Software A AND Software B Installed. I have found reports that will do if software A OR Software B is Installed, but that will not work for what i am trying to accomplish.

I look forward to any ideas that anyone has.

Thank you!

[lmiller]

After a few adjustments to include some more collumns I wanted this worked perfectly!

Thank you so much!!

[RCorbeil · Accepted solution]

One approach, where the example software titles to look for are Chrome and Firefox:

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
  tblAssetCustom.State = 1
  AND tblAssets.AssetID IN (SELECT tblSoftware.AssetID
                            FROM tblSoftware
                              INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.SoftID
                            WHERE tblSoftwareUni.SoftwareName = 'Google Chrome')
  AND tblAssets.AssetID IN (SELECT tblSoftware.AssetID
                            FROM tblSoftware
                              INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.SoftID
                            WHERE tblSoftwareUni.SoftwareName LIKE 'Mozilla Firefox%')