Printer Almost out of Toner Audit

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.

 

Click to Open - 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 %]

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting