→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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

View solution in original post

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