Java version reporting

[RJFIS]

Hi All,

Please forgive the newbie question... I just got Lansweeper installed recently, and am looking for a way to pull a list of all Java versions installed on servers only. Some of our servers have multiple versions of Java.

When I enter "Java" in the general search box, I get a listing of all versions we have in the environment, but I don't know how to get it organized into a list (.csv ideally).

Thanks,
Ryan

[Esben_D · Accepted solution]

This was sent to you via e-mail as well, however, in order to share this with the community and help others in the future, I'll add the report below.

For future reference, if you want to only show servers in a report you can do so by using the following where condition: tblComputersystem.Domainrole > 1

Below is the report which shows all servers which have the software with 'Java' in the name of a software installed on it.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tblSoftware.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And tblState.Statename =
  'Active' And tblComputersystem.Domainrole > 1