Coming from an ISP background as I do, you might be able to get around this with little coding.

We use Cricket graphing (like MRTG) to check dialup line usage for all of our gear. This tells us numerically how busy we are. We have a full report for all of our cities statically written to a website and re-gen'd daily.

We also have all the RADIUS accounting data in a sql db and scripts in front of it to check based on username, ip and start/stop date. It's not fast, but it does give us the info we want. The db stores username, ip, start time, stop time and all the other goop with radius. the search page lets you search on username, ip, start and stop times only.

This may not solve your programming problem, but it may give the higher ups enough information to get what they need without you having to break your back and reinvent the wheel 18 times

In reply to Re: How to do session times The Right Way by unwiki
in thread How to do session times The Right Way by strider corinth

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.