Report Generation

[Gabrielleal]

Hi All, 

I started using Lansweeper Recently and still trying to find my way on creating reports. 

I would like to create a report that would return the below information 

- Device name

- Installation path 

- java version 

- Collection date 

This information would help us identify all devices running any version of java on our network. 

If anyone could advise on this it would be very much appreciated

Thank you!

[Josha]

This is a report I've built for another piece of software.  I modified the where statement for Java X Update X.

SELECT 
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblSoftwareUni.SoftwarePublisher,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.InstallLocation,
tblSoftware.Installdate,
tblSoftware.Lastchanged,
tblAssets.Lastseen,
tblAssets.Username,
tblADusers.Displayname

FROM
tblAssets 
Inner Join tblAssetCustom on tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tblSoftware on tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni on tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblADusers on tblADusers.Username = tblAssets.Username

WHERE
tblSoftwareUni.softwareName like '%java%update%'