Printer Dashboard

[Dinge]

I am trying to run  2 things, I need a Dashboard that will show me all printers on my network that are monitored. And their Toner levels.

When one runs below a certain level i need a report sent to me/Service now so that we can handle this before it goes out. and get toner in stock...

Can someone help me get a dashboard working correctly.

[ErikT]

@Dinge ,

as a quick tip. If you find yourself in need of a custom report, make sure to check out our extensive report library https://www.lansweeper.com/resources/report

Here you'll find many additional reports that will get the results you are after or you can use as a base and customize to your needs. 

There is one specific for toner levels also.
https://www.lansweeper.com/resources/report/hardware/printer-toner-level/

[Mister_Nobody]

Begin from report:

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

[Dinge]

Thank you for the start of this code, 

How do i make it only show Printers that have a name that Start With CLB

[Mister_Nobody]

add to where

and tblAssets.AssetName like 'CLB%'

[DavidPK]

Hi Dinge,

To assist you better, could you tell us where you are attempting to create this dashboard within Lansweeper?

• On-prem installation
• Cloud Views 
• BI dashboards

[Dinge]

I am using both the On-Prem Installation. Which is synced to our cloud views. 
I have on prem, though most of team has cloud only for viewing.

+