→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
friedbad
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
friedbad
Engaged Sweeper II

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

Thanks
Hemoco
Lansweeper Alumni
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