Report that displays all monitor serials that are connected to workstations from an IP location

[MasterControl00]

Hi,

I have an IP location Overview for a particular office and I want to get all monitor serials in a report for that office.

I can see the asset relationship when I mouse over the workstation in the IP location view but there's no way to export that to Excel for example.

Any ideas on creating a custom report that will get me the monitor serials?

[rgross · Accepted solution]

This should be able to get you started in the right direction, you can customize it to fit your needs


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Username,
tblMonitor.MonitorModel,
tblMonitor.SerialNumber,
tblMonitor.LastChanged
From tblMonitor
Inner Join tblAssets On tblAssets.AssetID = tblMonitor.AssetID
Order By tblAssets.AssetUnique