Search Again: Re: raddct and ICraduis From: Lewis Watson Date: Tuesday, June 17, 2003 Time: 2:14:48 pm > I am trying to get usage from icradius. I have the following setup for > hooks but it doesn't seem to work. What sql scripts is someone else using > for this. > > SELECT UserName,count(UserName),sum(AcctSessionTime) FROM radacct WHERE > AcctStartTime >= '<Y1>-<M1>-<D1>' AND AcctStopTime <= '<Y2>-<M2>-<D2>' GROUP > BY UserName I use this with GnuRadius and Optigold for monthly usage... SELECT user_name,count(user_name),sum(acct_session_time),((sum(acct_input_octets) ) + (sum(acct_output_octets))) /1048576.0 FROM calls WHERE event_date_time >= '<Y1>-<M1>-<D1>' AND event_date_time <= '<Y2>-<M2>-<D2>' group by user_name and for user history... SELECT event_date_time,'',acct_session_time,acct_output_octets/1048.0,framed_ip_a ddress,connect_term_reason,nas_port_id,connect_speed FROM calls WHERE user_name = '<Login>' ORDER BY event_date_time desc HTH, Lewis --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: raddct and ICraduis by Patti Jones on Jun 17, 2003 at 2:04:49 pm Re: raddct and ICraduis by Lewis Watson on Jun 17, 2003 at 2:14:48 pm Re: raddct and ICraduis by Optigold List on Jun 17, 2003 at 11:00:38 pm