Report on Printers

[pjayme]

I'm trying to get a report with the Printer Device Name's, printer model's, IP, location and Serial Number in 1 report.

Any help would be appreciated.

Thank you.
Jayme

[pjayme]

Perfect.
Thank you.

[Hemoco]

Please try the report below.

Select tblCustDevices.Displayname, tblCustDevices.Vendor,
tblCustDevices.Ipaddress, tblCustDevices.Location,
web40AllIPLocationsDev.IPLocation, tblCustDevices.Serialnumber
From tblCustDevices Left Join
web40AllIPLocationsDev On web40AllIPLocationsDev.DeviceKey =
tblCustDevices.DeviceKey
Order By tblCustDevices.IPNumeric

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.