Printer by IP Location

[manitoulin]

I'm looking for a report that will give me the following info

Device Type = printer

Device Name
IP Address
Device Vendor
Device Model
IP Location <- from the web40AllIPLocations

[Hemoco · Accepted solution]

Please use the report below for the information you are after.

Select Top 1000000 tsysDevicetypes.ItemTypeIcon10 As icon, tblCustDevices.DeviceKey, tblCustDevices.Displayname As [Device name], tblCustDevices.Ipaddress As IP, tblCustDevices.Vendor, tblCustDevices.Model, web40AllIPLocationsDev.IPLocation From tblCustDevices Inner Join tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Left Join web40AllIPLocationsDev On web40AllIPLocationsDev.DeviceKey = tblCustDevices.DeviceKey Where tsysDevicetypes.ItemTypename = 'printer' 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.