Mail traffic accounting

[kilburn]

ispcomm Wrote:Maybe I'm missing something. The hash table that can be constructed using data from the "big" sql query will give you a "forwarded address" -> "local domain" mapping.

You are missing the fact that there may be multiple local domains that forward to the same address. Example:

user@local-dmn1.com -> user@external.dmn
user@local-dmn2.com -> user@external.dmn

So how do you know if the delivery should be accounted to local-dmn1 or local-dmn2?