Total Data download

[Mike]

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.
>
> Please share the solution.
>
> Best regards,
>
> Fazal Ahmed Malik
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>    

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120226/2a94f654/attachment.html>