Re: Freeradius GUI admin headaches

[Robert Haskins]

Can you point me to, or do you have an example MySQL query I could use 
for gathering "unique user/month count data" from the totacct/mtotacct 
tables? There doesn't seem to be anything in the stock dialupadmin 
program that does anything with these tables, though I know next to 
nothing about MySQL or PHP for that matter.

Thanks for any help you can provide.

Kostas Kalevras wrote:

Regarding my additional functionality requirement, I need a report that
shows the number of unique users who had sessions during the month. So
if I had 347 individual accounts (User-Name attribute) access the system
for the input time period, the system would report 347. This is
independent of/in addition to the count of sessions, time or MB downloaded.


You can easily use the totacct/mtotacct tables.


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html