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/
