cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
edolle
Engaged Sweeper
New Lansweeper User Here.

Is there a way I can sent a notification when a printer is low on toner? I'm sure I can setup SNMP on the printers but how do I use that to provide notifications?
5 REPLIES 5
vqT4cDoP9iXyMZw
Champion Sweeper
Looking at your custom report, you're pulling the TonerRemaining and TonerMaximum values. The canned "Device: Printer toner level" report takes it one step further, dividing the TonerRemaining value by the TonerMaximum value in order to calculate a percentage. I would suggest using this logic

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 dbo.tblCustDevPrinter
Inner Join dbo.tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
Inner Join dbo.tsysAssetTypes On
tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join dbo.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 %]

Similarly, the canned "Device: Printer almost out of toner" report, uses the calculation and then limits the results to 0-10% remaining:

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


Your report and the 2 canned reports all provide results in my environment. If your reports are coming up empty, check to make sure the SNMP community string you have set in Lansweeper Scanning Credentials, and confirm SNMP is enabled and the same login is used on the printer assets you're scanning. Since you said you have new printers, I'd guess either SNMP is not enabled, or if it is, those printers are using a different SNMP community string than the old printers they replaced. You'll need to address that either directly on the printers, or by adding a new SNMP credential (or editing the existing global SNMP) to match the printer configuration and mapping that credential to the IP ranges or other scan types used to discover the printers.
edolle
Engaged Sweeper
Here is the code. I think the problem is the snmp settings but I am not sure. This report, when run, comes up empty.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Lastseen,
tblAssets.Lasttried,
Cast(tblCustDevPrinter.TonerRemaining As nvarchar) +
'%' As RemainingPercentage,
tblCustDevPrinter.TonerMaximum,
tblCustDevPrinter.Tonername,
tblCustDevPrinter.TonerColorName,
tblCustDevPrinter.Lastchanged
From tblCustDevPrinter
Inner Join tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysAssetTypes.AssetTypename = 'Printer' And
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 tblState.Statename = 'Active'
Order By RemainingPercentage,
tblAssets.Domain,
tblAssets.AssetName
edolle
Engaged Sweeper
Thanks , everyone. I found two reports - one runs in the morning and on runs in the afternoon. They both report on the status of the toner for our printers. Since we installed new printers and removed the old the report is now blank. From the Edit Report screen I cannot make heads or tails of where this report is getting the printer information from.
I am also not sure what exactly to post on here to show what I am seeing as I do not know what information is useful.
What can I post in the forum so that everyone can see what I am seeing and point me in the right diretion?
Richie_Rich
Lansweeper Employee
Lansweeper Employee
Hey SirLoinOfBeef - Welcome as a new Lansweeper user !

Here is how to scan network devices and how to rep[ort on low toner:

https://www.lansweeper.com/knowledgebase/network-device-scanning-requirements/
https://www.lansweeper.com/report/printer-almost-out-of-toner-audit/

Also Here's a Knowledgebase article on sending report alerts:

https://www.lansweeper.com/knowledgebase/sending-email-alerts/

Thanks for being part of the Lansweeper Community.

Richie_Rich wrote:
Hey SirLoinOfBeef - Welcome as a new Lansweeper user !

Here is how to scan network devices and how to rep[ort on low toner:

https://www.lansweeper.com/knowledgebase/network-device-scanning-requirements/
https://www.lansweeper.com/report/printer-almost-out-of-toner-audit/

Also Here's a Knowledgebase article on sending report alerts:

https://www.lansweeper.com/knowledgebase/sending-email-alerts/

Thanks for being part of the Lansweeper Community.



Thanks! Unfortunately when I find the printer report for almost out of toner it comes up blank. Do I need to specify an IP? When I look at the printer list they all show the toner levels but I cannot figure out how to get the built in or the report my predecessor created (see below) to show the status of the toner. Help!

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now