List Printers

[kyle_vlaming]

I am trying to create a list of printers that are connected to our user's computers.

Not all of the printers are networked, so they don't show up in the IP scans. Most of the printers I want to list can be found in Config>Devices>Printers on an asset page, so they are stored in the database somewhere. I just cant find the table in report builder to build a report to show them. So far, I have been going to each asset and going into the printers page and copying to excel.

[RTI_IT · Accepted solution]

I had this same task and somebody on here was nice enough to help me out so I'll pay it forward, create a new report and use the following code:

Select Top 1000000 tsysOS.Image As Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.IPAddress As IP,
tblPrinters.Caption As Printer,
tblPrinters.Portname As [Printer Port],
tblPrinters.Capabilitydescriptions As [Printer Capabilities],
tblPrinters.Lastchanged,
tblAssets.Username
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where (tblPrinters.Portname Like 'DOT4%' Or tblPrinters.Portname Like 'USB%')
And tblPrinters.Local = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
Printer