On Fri, Feb 20, 2004 at 11:45:18PM +1100, Raymond wrote: > Hi, > > I have learned freeradius for a couple of days. I got the usage SQL query. Does > anyone have a look and see if it is correct? I am really appreciated for your time. > > Select AcctStartTime, AcctStopTime, AcctSessionTime, AcctInputOctets, > AcctOutputOctets from radacct where UserName='username1' > > Then sum caculate AccInputOctets and AccOutputOctets for both download and upload. >
If you want to get sum then you can use : SELECT sum(AcctSessionTime) AS total_time, sum(AcctInputOctets) AS total_in, sum(AcctOutputOctets) AS total_out FROM radacct WHERE UserName='username1' GROUP BY UserName; - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html