Find All Printers Which Are out of Toner
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 solve printers being out of toner. The audit shows printers and which specific toner is empty, allowing you to make sure that once they run out, they are not out of order for long and a new toner cartridge is installed as soon as possible.
Combining this audit with alerts allows you to be alerted when toner levels run out so you don't have to run the audit daily yourself or wait for complaints.
Printer out of Toner Query
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetName, tblAssetCustom.Model As [Device model], tblAssets.AssetID, tblCustDevPrinter.TonerRemaining, tblCustDevPrinter.TonerMaximum, tblCustDevPrinter.Tonername, tblCustDevPrinter.Lastchanged 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 Where tblCustDevPrinter.TonerRemaining = 0 And tblCustDevPrinter.TonerMaximum > 0 And tblAssetCustom.State = 1 Order By tblCustDevPrinter.TonerRemaining