Printer per Device Report

[VanDutch]

Looking to create a report that pulls all of the printers installed on each device into one long report. I know If I go to 1 device, click on 'Config' -> 'Devices' -> 'Printer' it will list the printers on that specific PC but I want a full list.

Eg:

Device__________Caption_________________________Portname________________Location
Computer001_____Microsoft XPS Document Writer________XPSPort:____________________-
Computer001_____Fax______________________________SHRFAX:___________________-
Computer001_____\\PRINTSVR\Printer25________________IP_###.###.###.25___________HR
Computer001_____\\PRINTSVR\Printer09________________IP_###.###.###.9____________CEO
Computer023_____Microsoft XPS Document Writer________XPSPort:____________________-
Computer023_____Fax______________________________SHRFAX:___________________-
Computer023_____\\PRINTSVR\Printer11________________IP_###.###.###.11___________Payroll
Computer023_____\\PRINTSVR\Printer02________________IP_###.###.###.2____________Housekeeping
...

Thanks,

[Hemoco · Accepted solution]

A sample printer report can be seen below. Note that Lansweeper only scans printers that are installed for a computer as a whole, not for individual users. If you're interested in building custom reports, we would recommend reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. If you know how to build SQL queries, then you'll know how to build Lansweeper reports as well. There are several good SQL tutorials available online, e.g.: http://www.w3schools.com/sql/default.asp

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblPrinters.Caption,
tblPrinters.Portname,
tblPrinters.Sharename,
tblPrinters.Location,
tblPrinters.Lastchanged
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Order By tblAssets.Domain,
tblAssets.AssetName,
tblPrinters.Caption

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.