→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !
a week ago
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!
a week ago
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%'
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now