Accounting interim data delta

Alan DeKok aland at
Sun Jun 26 13:26:53 CEST 2016

On Jun 26, 2016, at 7:14 AM, liran kessel <lirankessel at> 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.

More information about the Freeradius-Users mailing list