report: Printer out of Toner

[BrianM]

Accidentally overwrote report trying to add pages printed. Now it only shows printers with toner = 0, not up to 10% like it had.

Can someone please post the SQL of the printer out of toner report up so I can restore it?

Thanks!

[BrianM]

thanks!

[Hemoco · Accepted solution]

You can find the report down here:

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