Notification

Icon
Error

USB printers with toner levels

Posted: Monday, November 19, 2018 8:39:10 PM(UTC)
ajokerst

ajokerst

Member Original PosterPosts: 6
0
Like
Hi there,

I was wondering if there was a report that can be made that can pull all of the USB printers that are connected to computers (I have some code below that I pulled from a different thread)but also have a column for toner. Is this possible?

Code:
Select Top 1000000 tsysOS.Image As Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.IPAddress As IP,
tblPrinters.Caption As Printer,
tblPrinters.Portname As [Printer Port],
tblPrinters.Capabilitydescriptions As [Printer Capabilities],
tblPrinters.Lastchanged,
tblAssets.Username
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where (tblPrinters.Portname Like 'DOT4%' Or tblPrinters.Portname Like 'USB%')
And tblPrinters.Local = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
Printer
vstevo
#1vstevo Member Posts: 2  
posted: 4/22/2021 5:49:38 PM(UTC)
I have the same question. Is there a way to scan and report on the toner levels of local USB-connected printers?
Thank you!
rader
#2rader Member Posts: 14  
posted: 4/23/2021 12:29:27 AM(UTC)
Not sure if this helps, but it's the report I use for my printers. Most all are IP based though.

Code:

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 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]
vstevo
#3vstevo Member Posts: 2  
posted: 4/23/2021 3:15:35 PM(UTC)
Thank you for the prompt response. Yes, unfortunately it only pulls IP printers, not the local ones connected by USB.
Lansweeper sees them, gives model number and which computers they are connected to, but I don't know how to scan them for toner levels.

Active Discussions

Report Center Microsoft Outlook email bug EX255650
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 2:30:16 PM(UTC)
Lansweeper Patch Tuesday May 2021
by  Esben.D  
Go to last post Go to first unread
Last post: 5/11/2021 8:13:06 PM(UTC)
Lansweeper Report showing only Wi-Fi Devices and MAC addresses
by  Andy.S   Go to last post Go to first unread
Last post: 5/11/2021 2:23:24 PM(UTC)
Lansweeper Modifying Purchase Date / Yearly Refresh Report
by  Cripple.Zero   Go to last post Go to first unread
Last post: 5/7/2021 7:06:47 PM(UTC)
Lansweeper Tweak LanSweepers Bios Version Audit to show Last Seen
by  Tyler M.  
Go to last post Go to first unread
Last post: 5/6/2021 8:22:40 PM(UTC)
Lansweeper Patch Volume Across Fleet
by  darren.kimber  
Go to last post Go to first unread
Last post: 5/5/2021 11:29:33 PM(UTC)