SQL Query Examples for FreeRadius

me at erikthiart.com me at erikthiart.com
Wed Sep 5 16:42:03 CEST 2018


Hello, 

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.



More information about the Freeradius-Users mailing list