Mapped Printers to Computer by User

[cward]

I would like to see what printers are mapped to what computers, it does not need sorted by user but just so as I can see all of the printers attached to a computer. Or even if I could see what users are connected to what printer.

Thank you!

[Daniel_B · Accepted solution]

Lansweeper won't be able to scan printers which only were installed for one single user. Only printers which have been installed for the whole machine are being scanned and stored in tblPrinters. Please find an example report below.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tblAssets.Lastseen,
  tblPrinters.Caption As Printer,
  tblPrinters.Portname,
  tblPrinters.Location,
  tblPrinters.Sharename
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblAssetCustom.State = 1 And tblPrinters.Printprocessor Not Like
  'winprint'
Order By tblAssets.AssetName,
  Printer