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 %]
