Jetzt Ausprobieren

Printer out of Toner Audit

Hardware Network Devices

Find All Printers Which Are out of Toner

Never get caught off guard again by empty printer toners. Printers will always be the bane of IT’s existence, with this audit you can solve printers being out of toner. The audit shows printers and which specific toner is empty, allowing you to make sure that once they run out, they are not out of order for long and a new toner cartridge is installed as soon as possible. Combining this audit with alerts allows you to be alerted when toner levels run out so you don’t have to run the audit daily yourself or wait for complaints.

 

Printer out of Toner Query

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssetCustom.Model As [Device  model],
  tblAssets.AssetID,
  tblCustDevPrinter.TonerRemaining,
  tblCustDevPrinter.TonerMaximum,
  tblCustDevPrinter.Tonername,
  tblCustDevPrinter.Lastchanged
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
Where tblCustDevPrinter.TonerRemaining = 0 And tblCustDevPrinter.TonerMaximum >
  0 And tblAssetCustom.State = 1
Order By tblCustDevPrinter.TonerRemaining

Show

Hide