→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Gabrielleal
Engaged Sweeper

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!

1 REPLY 1
Josha
Engaged Sweeper III

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%'