Below is the standard code for the printers almost out of toner.
How to add a filter on Ip location ? I've got multiple sites
Can you help me ?
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Model As [Device model],
tblAssets.AssetID,
Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
100) As [Remaining %],
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 Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
100) <= 10 And Floor(tblCustDevPrinter.TonerRemaining /
tblCustDevPrinter.TonerMaximum * 100) >= 0 And tblCustDevPrinter.TonerMaximum
> 0 And tblAssetCustom.State = 1
Order By [Remaining %]
