→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BrianM
Engaged Sweeper III
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!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
BrianM
Engaged Sweeper III
thanks!
Hemoco
Lansweeper Alumni
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