(RADIATOR) Track daily/monthly usage

[Joe Hughes]

Hi All

We record all our accounting information in a MS-SQL database,
including start, stop and alive packets at 1 hour intervals for each
session. In addition to the accounting data, I also record individual
sessions detailing the start and end dates, the input/output octs and
some other basic information. Periodically I flush the accounting
table of old data. This all works fine.

I'd like to go one step further and record daily usage for each user.
So for a given user I could see something like;

UserA    2006-05-28    2000   2000
UserA    2006-05-29    1000   1500
UserA    2006-05-30    5000   4500

I could then do a SUM() using the month to view monthly summaries.
There's also the possibility to use triggers to flag users exceeding
quotas.

Now I understand this can get quite complicated when sessions run from
one day to the next, one month to the next and perhaps multiple
sessions per day.

I'd be interested in finding out if anybody else is doing this, or
whether this isn't the best way of doing things, I may explore using
SNMP, although in some cases SNMP isn't an option with some of our NAS
devices.

I know I could do it using a combination of triggers, hard work and
various additional database logic, but it may introduce a lot of
overhead on the database, especially with a lot of concurrent
sessions. One option may be to increase the interim accounting
interval.

Cheers

Joe

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.