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

Ready to get started?

Explore the full platform, free for 14 days.
No credit card required.

Need help evaluating?
Get guidance on pricing at scale and enterprise requirements.
Talk to sales
Clear pricing as you grow
Transparent plans that scale with your environment.
View plans & pricing