Printer Inventory

[Mike_Williams]

We need to replace a server that has some shared printers defined on it. We have 50+ local users, with most having only IP-defined printers. Some users also have printers that are shared from the server in question. So we need to identify on each PC, which printers are configured using the IP address of the printer, and which printers are shared (and will become unavailable) when that server goes away.

I'm test driving Lansweeper for this purpose. But it does not seem to provide the defined printers info. Any guidance? Does Lansweeper provide the info in question? If so, how do I get to it?

Thx,

Mike

[Bart_E · Accepted solution]

This question was answered via email. FYI I added our response below:

When Lansweeper scans a Windows computer, it automatically retrieves information on the printers installed on the computer. You can find this information in the Config\Devices\Printer section of individual computer webpages. We included a sample report below as well that includes all of the installed printers, except for "virtual" ones like PDF printers. You can filter one or more of the columns within the report results, e.g. to list computers with a specific printer installed. Keep in mind that only printers installed for the computer as a whole are scanned. Printers installed for individual users are not. There is also a built-in report in the Reports tab "Printer: Shared printers" that you can use to list shared printers specifically.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblPrinters.Caption As Printer,
  tblPrinters.
Capabilitydescriptions,
  tblPrinters.Comment,
  tblPrinters.EnableBIDI,
  tblPrinters.Horizontalresolution,
  tblPrinters.Local,
  tblPrinters.Location,
  tblPrinters.Network,
  tblPrinters.Portname,
  tblPrinters.Printjobdatatype,
  tblPrinters.Printprocessor,
  tblPrinters.Sharename,
  tblPrinters.Status,
  tblPrinters.verticalresolution,
  tblPrinters.Lastchanged
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 tblPrinters.Printprocessor Not Like '%winprint%' And
  tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Printer