SQL Query Examples for FreeRadius

[Alan DeKok]

On Sep 5, 2018, at 10:42 AM, <me at erikthiart.com> <me at erikthiart.com> wrote:
> I hope someone would be so kind as to give me a heads up to some sample
> queries that users have found useful over the years, stuff I might not think
> of or know possible. 
> 
> Examples would be:
> Get current online users
> Get the average session time or average session time per username.
> Get the total data usage per nas
> Total users connected to a nas in a specific date range
> 
> And other queries you find useful.
> 
> This will help me and future radius users.

  All of this data should be in an SQL database.  You can use normal SQL queries to find this information.

  The schema for FreeRADIUS is well documented.

  Alan DeKok.