Accounting interim data delta

[liran kessel]

would you recommend doing it within the dialup.conf configuration? 

how would i configure it to do 3 steps:
Select
Update radacct
insert new table?


Thanks

> 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