Local Printer List

[bkleiman]

I need to create a report that would show if any local printers are installed on a PC.

[Hemoco · Accepted solution]

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

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.OSname As OS, Web40OSName.SP, tblComputers.LastknownIP As IP, tblPrinters.Caption As Printer, tblPrinters.Lastchanged From tblComputers Inner Join tblPrinters On tblComputers.Computername = tblPrinters.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where tblPrinters.Local = 1 And tblPrinters.Network = 0 Order By tblComputers.ComputerUnique, tblPrinters.Caption

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.