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 Full asset report with and without ad relationship
by  teddyh2o   Go to last post Go to first unread
Last post: 6/18/2021 8:28:24 PM(UTC)
Report Center Show newly discovered software
by  CyberCitizen  
Go to last post Go to first unread
Last post: 6/16/2021 12:06:21 AM(UTC)
Lansweeper Multiple Devices Owned by Users (asset relations)
by  Charles S.   Go to last post Go to first unread
Last post: 6/15/2021 9:38:26 PM(UTC)
Lansweeper Show Date Without Time
by  RC62N  
Go to last post Go to first unread
Last post: 6/15/2021 9:04:47 PM(UTC)
Lansweeper Windows 10 Version Chart
by  RC62N   Go to last post Go to first unread
Last post: 6/14/2021 6:16:52 PM(UTC)
Lansweeper LSAgent Report
by  brodiemac-too  
Go to last post Go to first unread
Last post: 6/14/2021 5:27:29 PM(UTC)