Get Daily Usage: Repeat Question

Alan DeKok aland at
Sun Dec 2 20:10:15 CET 2018

On Dec 2, 2018, at 12:28 PM, Imdad Hasan <imdadalikadiwala0 at> wrote:
> *Question: How can i make daily usage report with freeradius.*

  In short you don't.  The accounting data is in a database.  You ask the database for that information.

> if any user "XYZ" have a one accounting session with the
> acct-start-time = "2018-08-16
> 05:00:00" and acct-stop-time = " 2018-08-19 11:16:46". Ok. Means only one
> accounting session 3 days. So, in this example how can i calculate OR get
> the "2018-08-17" OR "2018-08-18" s' data usage of that  "XYZ" user?

  If the users session spans multiple days, then there's no way to get the usage for each day.

  If you want to track daily session usage, you must edit the default queries, and likely the schema, in order to track that information.

  Alan DeKok.

More information about the Freeradius-Users mailing list