Reporting from logs

[Phil Mayers]

On 25/09/12 14:00, Leal, Paulo wrote:
> Hi guys,
>
> We are new to eduroam and we are using FreeRadius for authentication and
> connection to national proxies.
>
> Just wondering what kind of reporting you have managed to get out from
> the FreeRadius logs, we wanted some user friendly reports with user
> numbers, success and failed attempts, what realms were used and numbers,
> even possibly bandwidth consumed per user. Daily, weekly and monthly
> reports.
>
> Would be grateful to find out what everyone is using to achieve this and
> if someone has some sample reports would be great.

We use post-auth SQL logging and accounting to SQL, and I generate the 
reports from an SQL job.