SQL Query Examples for FreeRadius
aland at deployingradius.com
Wed Sep 5 17:03:51 CEST 2018
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.
More information about the Freeradius-Users