Accounting interim data delta
lirankessel at gmail.com
Sun Jun 26 13:30:39 CEST 2016
would you recommend doing it within the dialup.conf configuration?
how would i configure it to do 3 steps:
insert new table?
> On 26 Jun 2016, at 2:26 PM, Alan DeKok <aland at deployingradius.com> wrote:
> On Jun 26, 2016, at 7:14 AM, liran kessel <lirankessel at gmail.com> wrote:
>> What we need is to be able to know what was the delta of acctinputoctets and acctoutputoctets that was received in this event , in comparison to the data that was already in the DB from the previous notifications.
>> Can I somehow enter this delta into a different table that will show me the usage for each notification?
> You need to calculate the delta first. Write a SELECT statement which grabs the current value from the DB, and then subtract it from the current value of the attribute. Put the result into the SQL table.
> Alan DeKok.
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
More information about the Freeradius-Users