Notification

Icon
Error

Report of list of assets - List of assets with JAVA version lower than one determined.

Posted: Tuesday, May 4, 2021 9:42:34 AM(UTC)
Carlos Montes

Carlos Montes

Member Original PosterPosts: 2
0
Like
Hello!

i want to create a report with a list of assets that are not servers nor workstations(only laptops) and that have e.g a java version lower than 291 It has to include the list of assets (hostname, user that uses that machine).

Is posible to avoid duplicate rows?I mean it may show duplicate information like JAVA 32 bits and 64 for the same hostname.


Thanks for advance!!
Brandon
#1Brandon Member Posts: 154  
posted: 5/4/2021 2:34:53 PM(UTC)
Try this:

Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblAssets
Inner Join tblBattery On tblAssets.AssetID = tblBattery.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join lansweeperdb.dbo.tblSoftware On tblAssets.AssetID =
tblSoftware.AssetID
Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'java%' And
tblSoftware.softwareVersion Not Like '%291%' And tblAssetCustom.State = 1 And
tblBattery.DeviceID Is Not Null
Order By tblAssets.AssetName
Carlos Montes
#2Carlos Montes Member Original PosterPosts: 2  
posted: 5/4/2021 2:52:15 PM(UTC)
Thanks a lot, im newbie and im so out of practice of SQL code, looks working, Applause

Active Discussions

Lansweeper Enterprise Options in Menu Bar/Configuration
by  mk@allan   Go to last post Go to first unread
Last post: 6/18/2021 7:38:43 PM(UTC)
Lansweeper No One getting back to me from Lansweeper
by  Kenneth Lindsay  
Go to last post Go to first unread
Last post: 6/18/2021 3:31:06 PM(UTC)
Lansweeper INFO DateTimeService time refresh
by  miharix   Go to last post Go to first unread
Last post: 6/18/2021 10:48:57 AM(UTC)
Lansweeper RPC Unavailable error
by  Greeno  
Go to last post Go to first unread
Last post: 6/17/2021 7:15:07 PM(UTC)
Lansweeper Exclude Search
by  pryan67  
Go to last post Go to first unread
Last post: 6/16/2021 4:01:43 PM(UTC)
Lansweeper Report: All Apple Mac devices with Memory RAM asset
by  gabrielo   Go to last post Go to first unread
Last post: 6/16/2021 3:17:24 PM(UTC)
Lansweeper Does technical support for LS really respond?
by  tosch  
Go to last post Go to first unread
Last post: 6/16/2021 12:48:50 PM(UTC)