That was very useful, I was able to cut and paste in into Excel so I could sort. You seem to have gotten the UL and DL labels backward. And the total ends up in the same column as the "UL" number.
Another issue is that there are some accounting records that cross the first of the month. Is there any way to force an accounting record daily? -----Original Message----- From: wireless-boun...@wispa.org [mailto:wireless-boun...@wispa.org] On Behalf Of Tim Sylvester Sent: Monday, October 12, 2009 4:47 PM To: 'WISPA General List' Subject: Re: [WISPA] FreeRadius / Accounting data If you store the accounting data in MySQL, you can perform the following SQL query to list the number of bytes Downloaded, Uploaded, Total Bytes by user for a give time period. select username, sum(acctinputoctets) as Download, sum(acctoutputoctets) as Upload, sum(acctinputoctets + acctoutputoctets) as "Total Bytes" FROM radacct where acctstarttime BETWEEN '2009-06-01' and '2009-07-01' group by username; Tim > -----Original Message----- > From: wireless-boun...@wispa.org [mailto:wireless-boun...@wispa.org] On > Behalf Of Mark McElvy > Sent: Monday, October 12, 2009 8:51 AM > To: WISPA General List > Subject: [WISPA] FreeRadius / Accounting data > > I am running FreeRadius and FreeSide usinf PPPoE. Freeside currently > does not give me the reports I need for my accounting data. When I run > a > report, it gives you details on each record but does not give you > totals > for each user. I would like to generate a report that would give me > upload/download totals for a given time period. Anyone know of software > I can run against the FreeRadius accounting data to get this info or > have any Freeside customization that would like to share to do this? > > > > I am looking at bitcap bill if you have not guessed;) > > > > Mark McElvy > AccuBak Data Systems, Inc. > > > > > > > > ----------------------------------------------------------------------- > --------- > WISPA Wants You! Join today! > http://signup.wispa.org/ > ----------------------------------------------------------------------- > --------- > > WISPA Wireless List: wireless@wispa.org > > Subscribe/Unsubscribe: > http://lists.wispa.org/mailman/listinfo/wireless > > Archives: http://lists.wispa.org/pipermail/wireless/ ------------------------------------------------------------------------ -------- WISPA Wants You! Join today! http://signup.wispa.org/ ------------------------------------------------------------------------ -------- WISPA Wireless List: wireless@wispa.org Subscribe/Unsubscribe: http://lists.wispa.org/mailman/listinfo/wireless Archives: http://lists.wispa.org/pipermail/wireless/ -------------------------------------------------------------------------------- WISPA Wants You! Join today! http://signup.wispa.org/ -------------------------------------------------------------------------------- WISPA Wireless List: wireless@wispa.org Subscribe/Unsubscribe: http://lists.wispa.org/mailman/listinfo/wireless Archives: http://lists.wispa.org/pipermail/wireless/
