USB printers with toner levels

[ajokerst]

Hi there,

I was wondering if there was a report that can be made that can pull all of the USB printers that are connected to computers (I have some code below that I pulled from a different thread)but also have a column for toner. Is this possible?

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

[rader]

Not sure if this helps, but it's the report I use for my printers. Most all are IP based though.

Select Top 1000000 tblAssetCustom.Model,
  tblCustDevPrinter.TonerRemaining As [Copies Left],
  tblCustDevPrinter.TonerMaximum As [Max. Copies],
  Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
  100) As [Remaining %],
  tblCustDevPrinter.Tonername As [Reorder #],
  tblCustDevPrinter.TonerColorName As Color,
  tblAssets.IPAddress,
  Case
    When (tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
      100) <= 10 Then 'red'
  End As foregroundcolor,
  Case
    When (tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
      100) <= 10 Then 'yellow'
  End As backgroundcolor,
  tblAssetCustom.SnmpOID,
  tblAssetCustom.Printedpages,
  tblAssetCustom.Printerstatus
From tblCustDevPrinter
  Inner Join tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
      And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblCustDevPrinter.TonerRemaining >= 0 And tblCustDevPrinter.TonerMaximum >
  0 And tblAssetCustom.State = 1
Group By tblAssetCustom.Model,
  tblCustDevPrinter.TonerRemaining,
  tblCustDevPrinter.TonerMaximum,
  tblCustDevPrinter.Tonername,
  tblCustDevPrinter.TonerColorName,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.SnmpOID,
  tblAssetCustom.Printedpages,
  tblAssetCustom.Printerstatus
Order By tblAssetCustom.Model,
  [Copies Left]

[vstevo]

Thank you for the prompt response. Yes, unfortunately it only pulls IP printers, not the local ones connected by USB.
Lansweeper sees them, gives model number and which computers they are connected to, but I don't know how to scan them for toner levels.

[vstevo]

I have the same question. Is there a way to scan and report on the toner levels of local USB-connected printers?
Thank you!