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
Explore the full platform, free for 14 days.
No credit card required.