Report to show computers using the same network printer

[tundra96]

How would I create a report to show computers using the same network printer. I want to be able to run a report with the printers DNS name or IP address and have it show me all the workstations that are using the printer.

Thanks

[Daniel_B · Accepted solution]

Please try the report below for the information you are after. You can filter the printer name/IP within the report results.

Select Top 1000000 tblPrinters.Sharename,
  tblPrinters.Caption,
  tblPrinters.Comment,
  tblPrinters.Portname,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Right Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblPrinters.Sharename Is Not Null And tblAssetCustom.State = 1
Order By tblPrinters.Sharename,
  tblAssets.AssetName