Network Printers

Find All Network Printers on Your Network

List all installed network printers in your network easily with this report. Lansweeper retrieves installed network printers on your network and by using the report below you get an overview of all the network printers found in your environment.

 

Installed Network 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.Printprocessor <> 'WinPrint' And Case tblPrinters.Network
    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