PRUEBA AHORA

Printer Almost out of Toner Audit

Hardware Network Devices

Find All Printers Which Are Almost 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 proactively solve printers being out of toner. The audit shows printers and which specific toner is low, allowing you to make sure that once they run out, a new one is ready. Combining this audit with alerts allows you to be alerted when toner levels run low so you don’t have to run the audit daily yourself or have to wait until the toner is empty before ordering extra.

 

Printer Almost out of Toner Query

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssets.AssetID,
  Case
    When tblCustDevPrinter.TonerMaximum = 0 Or
      tblCustDevPrinter.TonerRemaining = 0 Then 0
    Else Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum
      * 100)
  End As [Remaining %],
  tblCustDevPrinter.TonerMaximum,
  tblCustDevPrinter.Tonername,
  tblCustDevPrinter.Lastchanged,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen
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 Outer Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblCustDevPrinter.TonerMaximum <> 0 And tblCustDevPrinter.TonerMaximum > 0
  And tblCustDevPrinter.TonerRemaining <> 0 And
  Floor(tblCustDevPrinter.TonerRemaining / (Case
    When tblCustDevPrinter.TonerMaximum = 0 Then 1
    Else tblCustDevPrinter.TonerMaximum
  End) * 100) <= 10 And Floor(tblCustDevPrinter.TonerRemaining / (Case When tblCustDevPrinter.TonerMaximum = 0 Then 1 Else tblCustDevPrinter.TonerMaximum End) * 100) >= 0 And tblAssetCustom.State = 1
Order By [Remaining %]

Show

Hide