Java Versions for systems with "X" software.

[friedbad]

I'm looking for a report that will display the following:

All systems with "software A" installed on them plus all of the Java versions %java% that they have on them.

I've looked around but can't seem to find what I need in previous topics. I'm sure someone has asked for a similar report before.

Lansweeper version: 5069

[friedbad]

Works great, and I've already found another use for it already!!

Thanks

[Hemoco · Accepted solution]

Please use the report below.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
SubQuery1.softwareName As JavaName,
SubQuery1.SoftwarePublisher As JavaVersion,
SubQuery1.softwareVersion As JavaPublisher,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select tblSoftware.AssetID,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%java%') SubQuery1
On SubQuery1.AssetID = tblAssets.AssetID
Where tblSoftwareUni.softwareName = 'SoftwareA' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName