→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mweist
Engaged Sweeper
Hello All,

I am looking for some help on running a report with the following info:

-Asset Number
-Asset Make/Model
-Displays Connected w/Serial Numbers

Some workstations may have more than 1 monitor, typically 2

They are Samsung Displays that we are looking for, it looks as though this info is captured. Not sure how to get it to a report. I found some old reports for this, but they don't work with the current lansweeper.

Any help or direction pointing would be great, Thank you!
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
This should work for you:

Select Top 1000000 tblAssets.AssetID As [Asset number],
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblMonitor.MonitorManufacturer,
tblMonitor.MonitorModel,
tblMonitor.SerialNumber,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblMonitor On tblAssets.AssetID = tblMonitor.AssetID
Where tblAssetCustom.State = 1
Order By [Asset number]