Printer: Out of toner (Built-in)

[Daniel_B]

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