Re: How can I determine average per customer utilization

Dave Kennedy (davek@muscle.net)
Sun, 10 Nov 1996 13:26:20 -0500 (EST)

Mark Colasante writes...
> We would like to begin tracking some statistical information for our dialup
> Internet access services. We are using PM2e units and the Microcom ISPorte
> racks as well as Cisco 2501 routers. We are not using any SNMP tools, nor
> do we currently offer ISDN dial-up. What are some ways that we can derive:
>
> 1. Average hours online per customer per month.
> 2. Average bandwidth used per customer per month.
>
> We do use radius accounting but don't really have any utilities to analyze
> the data.
>
> Any suggestions are appreciated. Also, if anyone has already determined
> their average per customer usage statistics, would you mind sharing some of
> your data so that we may compare our results?

Here's example output from what I use:

Username | logins | total time | avg time
------------------------------------------------
bob | 20 | 07:12:12 | 00:21:36
david | 40 | 07:48:08 | 00:11:42
dellis | 3 | 02:56:55 | 00:58:58
darren | 25 | 00:39:31 | 00:01:34
darlene | 2 | 00:07:44 | 00:03:52

This uses lineparser and summarize. Two scripts available in several
places. One of which is: ftp://ftp.Muscle.Net/pub/livingston. My
version of summarize prints the time in hh:mm:ss format rather than
total minutes.

davek

-- 
| Dave Kennedy (davek@muscle.net)             Voice: 770-368-1514 |
| Multi-User Systems, Inc.      Putting MUSCLE in Internet Access |