Report of Workstations and Displays w/Serial Numbers

[mweist]

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!

[Esben_D]

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]