Here is how I do it (this is for traffic in a particular month)
SELECT
username,
truncate(sum(acctinputoctets + acctoutputoctets) / 1000000,
1) traffic
FROM radacct
WHERE
month(acctstarttime) = 12 AND
year(acctstarttime) = 2011
GROUP BY username
This assumes you are using mysql for accounting.
Mike
On 25/02/12 17:49, Fazal Ahmed Malik wrote:
Hi,
Is there any tool or
script with help of which I can get to
know how much data downloaded by all user in last 30 days.