cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
manitoulin
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now