TRY NOW

Printer Toner Level

Hardware Network Devices

Find All Printers and Their Toner Levels Within Your Network

Never get caught off guard again by empty printer toners. Printers will always be the bane of IT’s existence, with this report you can solve printers being out of toner. The report shows printers and their current toner level in one overview. You can sort the results however you like to keep an eye on the toner levels and check which printer will need your attention in the foreseeable future.

 

Printer Toner Level Query

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssetCustom.Model As [Device  model],
  tblCustDevPrinter.AssetID,
  Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
  100) As [Remaining %],
  tblCustDevPrinter.Tonername,
  tblCustDevPrinter.Lastchanged
From tblCustDevPrinter
  Inner Join tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
  100) >= 0 And tblCustDevPrinter.TonerMaximum > 0 And tblAssetCustom.State = 1
Order By [Remaining %]

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.