Reports - Printers

[aeckrich]

Hey all, I am looking to set up a report that will get emailed to a specific email address when the following is triggered; Printers consumables are below 10% of usage left. IE. toner, imaging unit, etc.

If anyone has done something similar or knows how to go about this process, please let me know how. I really appreciate any help!

Thanks!

[beacampos]

Hello, @aeckrich , if the reply from @rader solves your query, it would be great if you can Accept that reply as a Solution. This increases the value of the Community for all the other users facing a similar problem as yours! Thank you 🙂

[rader]

This is my report that have on my dashboard. I've added the checking for the remaining toner "<=10 And >=0" line in the "Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum * 100)" expression. If you remove the checking statement, you'll get a pretty report that you can tag to a dashboard.

You should be able to take this report and now schedule an email report with it.

Good luck.

Select Top 1000000 tblAssetCustom.Model,
  tblCustDevPrinter.TonerRemaining As [Copies Left],
  tblCustDevPrinter.TonerMaximum As [Max. Copies],
  Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
  100) As [Remaining %],
  tblCustDevPrinter.Tonername As [Reorder #],
  tblCustDevPrinter.TonerColorName As Color,
  tblAssets.IPAddress,
  Case
    When (tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
      100) <= 10 Then 'red'
  End As foregroundcolor,
  Case
    When (tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
      100) <= 10 Then 'yellow'
  End As backgroundcolor,
  tblAssetCustom.SnmpOID,
  tblAssetCustom.Printedpages,
  tblAssetCustom.Printerstatus
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 Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
      And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblCustDevPrinter.TonerRemaining >= 0 And tblCustDevPrinter.TonerMaximum >
  0 And Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum
  * 100) <= 10 And Floor(tblCustDevPrinter.TonerRemaining /
  tblCustDevPrinter.TonerMaximum * 100) >= 0 And tblAssetCustom.State = 1
Group By tblAssetCustom.Model,
  tblCustDevPrinter.TonerRemaining,
  tblCustDevPrinter.TonerMaximum,
  tblCustDevPrinter.Tonername,
  tblCustDevPrinter.TonerColorName,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.SnmpOID,
  tblAssetCustom.Printedpages,
  tblAssetCustom.Printerstatus
Order By tblAssetCustom.Model,
  [Copies Left]