Monitor Serial Number Report

[pjayme]

I need to create a report for Monitor's with serial numbers. Any help would be greatly appreciated.

Thanks.

[pjayme]

Great. Thank you for such a quick response.
Beautiful. Very helpful.

Thanks again!

[Hemoco]

Please use the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblMonitor.MonitorModel, tblMonitor.SerialNumber,
tblMonitor.MonitorManufacturer, tblMonitor.ManufacturedDate,
tblMonitor.LastChanged
From tblComputers Inner Join
tblMonitor On tblComputers.Computername = tblMonitor.Computername
Order By tblComputers.ComputerUnique, tblMonitor.MonitorModel,
tblMonitor.SerialNumber

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.