Local Printers

Find All Local Printers in Your Network

List all installed local printers in your network easily the built-in report. Find printers not even connected to the network directly. Lansweeper retrieves installed local printers from Windows computers and by using the report below you get an overview of all the local printers found in your environment.

Installed local printers

Click to Open - Installed Local Printers Query
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblPrinters.Caption As Printer,
  tblPrinters.Portname As PrinterPort,
  tblPrinters.Printprocessor,
  tblPrinters.Capabilitydescriptions As PrinterCapabilities,
  tblPrinters.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblPrinters.Portname Not Like '%.%.%.%' And tblPrinters.Printprocessor <>
  'WinPrint' And Case tblPrinters.Network
    When 0 Then 'No'
    When 1 Then 'Yes'
  End = 'No' And Case tblPrinters.Local
    When 0 Then 'No'
    When 1 Then 'Yes'
  End = 'Yes' And tblState.Statename = 'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Printer

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting