[RADIATOR] Radius accounting log file analysis

[Bruno Tiago Rodrigues]

 Thanks, I'll have a look then at the goodies folder.
  Currently, we do not store the entire set of accounting logs on database.


Bruno Tiago Rodrigues


On Thu, Jul 19, 2018 at 7:18 AM Hugh Irvine <hugh at open.com.au> wrote:

>
> Hello Bruno -
>
> If you use an SQL database for your accounting records, you can easily do
> these sorts of things with an SQL report generator.
>
> There is also a Perl script in “goodies/reports” which may be useful for
> you.
>
> regards
>
> Hugh
>
>
> > On 18 Jul 2018, at 20:22, Bruno Tiago Rodrigues <
> bruno.tiago.rodrigues at gmail.com> wrote:
> >
> >
> >
> > Hi,
> >
> > I need to get some flexible analytics from RADIATOR accounting logs,
> namely:
> >
> > 1)      Active subscribers per node;
> >
> > 2)      Active subscriber per profile (VSA attribute present in the
> accounting logs);
> >
> > 3)      Average traffic per subscriber;
> >
> > 4)      Average traffic per subscriber per profile;
> >
> > 5)      Other kind of reports based on the attributes present in the
> logs;
> >
> > Are there any tools (off the shelf) known to do this kind of reports
> (paid or free)?
> >
> > Is SAWMILL one of them?
> >
> > Thanks in advance
> >
> > </Bruno Rodrigues
> > _______________________________________________
> > radiator mailing list
> > radiator at lists.open.com.au
> > http://lists.open.com.au/mailman/listinfo/radiator
>
>
> --
>
> Hugh Irvine
> hugh at open.com.au
>
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
> TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
> DIAMETER, SIM, etc.
> Full source on Unix, Linux, Windows, macOS, Solaris, VMS, NetWare etc.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.open.com.au/pipermail/radiator/attachments/20180719/0b495b3e/attachment.html>