Old name: Device: Printer out of toner (Built-in)
The report below lists printers out of toner
The report will only list assets that meet all of the following criteria:
- The asset state is set to "active".
- The asset type is set to "Printer".
- The toner level data available
- The toner level is 0%
SELECT
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename as AssetType,
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
tblCustDevPrinter.TonerMaximum <> 0
AND tblCustDevPrinter.TonerRemaining = 0
AND tblState.Statename = 'Active' And tsysAssetTypes.AssetTypename = 'Printer'
Order By RemainingPercentage, tblAssets.Domain, tblAssets.AssetName
