Is it possible to filter on IP location ?

[Joris_]

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 %]

[Joris_ · Accepted solution]

Solved

http://www.lansweeper.com/Forum/yaf_postst10743_Adding-IP-locations-to-a-report.aspx#post40242