Search Again: Re: bandwidth usage From: Patti Jones Date: Sunday, September 28, 2003 Time: 5:01:56 pm Thank you. That is working fine. Patti ----- Original Message ----- From: "Javier Galvez" <jcgalvez@MegaLink.com> To: <isp-list@optigold.com> Sent: Saturday, September 27, 2003 4:00 PM Subject: Re: [Optigold ISP] bandwidth usage > isp-list@optigold.com writes: > >I want to import the amount of bandwidth used by my customers. I am using > >icradius so the info is in the accounting table. I see several references > >in the archives but then another reference that the previous one didn't > >work. Does anyone have a working import of this? > > Patti, > > For importing (including monthly) I use: > > SELECT > UserName,count(UserName),sum(AcctSessionTime+(60-(AcctSessionTime%60))),sum( (((AcctInputOctets+AcctOutputOctets)/1024)/1024)) > FROM radacct WHERE AcctStopTime >= '<Y1>-<M1>-<D1>' AND AcctStopTime <= > '<Y2>-<M2>-<D2>' GROUP BY UserName; > > For STATEMENTS I use: > > SELECT > AcctStopTime,'',AcctSessionTime+(60-(AcctSessionTime%60)),AcctInputOctets+Ac ctOutputOctets,FramedIPAddress,NASIPAddress,NASPortId,AcctTerminateCause > FROM radacct WHERE UserName = '<Login>' ORDER BY AcctStopTime desc limit > 30; > > For Generic 1 statement: > > SELECT > AcctStopTime,(AcctSessionTime+(60-(AcctSessionTime%60)))/60,FramedIPAddress, AcctTerminateCause > FROM radacct WHERE UserName = '<Login>' ORDER BY AcctStopTime desc limit > 10; > > I use ICRADIUS for "proxy" authentication, and my main radius > authentication is running under MACRADIUS Works great for me. > > Javier Galvez > MegaLink > +(591)-715-22149 > jcgalvez@megalink.com > > > > --------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit http://www.optigold.com/lists/isp.html > --------------------------------------------------- > > --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: Bandwidth Usage by Enesha Fairluck on Oct 3, 2002 at 11:41:17 am Re: Bandwidth Usage by Shawn Hogan on Oct 4, 2002 at 5:29:25 am bandwidth usage by Patti Jones on Sep 27, 2003 at 1:05:05 pm Re: bandwidth usage by Javier Galvez on Sep 27, 2003 at 1:59:35 pm Re: bandwidth usage by Patti Jones on Sep 28, 2003 at 5:01:56 pm