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