Here is how I do it (this is for traffic in a particular month)
SELECT
username,
truncate(sum(acctinputoctets + acctoutputoctets) / 100,
1) traffic
FROM radacct
WHERE
month(acctstarttime) = 12 AND
year(acctstarttime) =
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.
Please share the solution.
Best regards,
Fazal Ahmed Malik
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
2 matches
Mail list logo