Accounting interim data delta

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


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.




More information about the Freeradius-Users mailing list