Re: Tracking port usage?

SLT Internet Connect (info@sltic.com)
Mon, 14 Apr 1997 10:00:51 -0500

At 09:49 PM 4/13/97 -0500, you wrote:
>Does anyone have a script that print out either the hours used, or the %
>used for each individual port in a radius detail file?
>
>I'd like to be able to see this so I can figure out if one particular port
>has a bad phone line or modem.
>
>Brian
>
>

I modified raquick to give some system use data:

It totals port use and percent in use (based on 30 day month).
Also gives some general customer averages logins/month, minute/login,
percent system in use. I use the NT port of radius, check attributes to
make sure they match your dictionary, change modem_count, and you'll want
to change the charge calculations.

File is at: http://www.sltic.com/racharge.pl.txt (or I can email to you)

Any improvement suggestions appreciated,

Bruce
info@sltic.com
SLT Internet Connect
_____________________________________________

Sample output (Please excuse the width)

System Port Usage
------------------------------------------------------------
207.*.*.* 0: Time Used: 35213.92 minutes Logins: 977 Percent of
Total Use: 13.93 Percent in Use: 81.51
207.*.*.* 1: Time Used: 32973.73 minutes Logins: 931 Percent of
Total Use: 13.04 Percent in Use: 76.33
207.*.*.* 2: Time Used: 30766.45 minutes Logins: 734 Percent of
Total Use: 12.17 Percent in Use: 71.22
207.*.*.* 3: Time Used: 27107.30 minutes Logins: 822 Percent of
Total Use: 10.72 Percent in Use: 62.75
207.*.*.* 4: Time Used: 23802.17 minutes Logins: 687 Percent of
Total Use: 9.41 Percent in Use: 55.10
207.*.*.* 5: Time Used: 20932.67 minutes Logins: 628 Percent of
Total Use: 8.28 Percent in Use: 48.46
207.*.*.* 6: Time Used: 18682.30 minutes Logins: 514 Percent of
Total Use: 7.39 Percent in Use: 43.25
207.*.*.* 7: Time Used: 14919.87 minutes Logins: 453 Percent of
Total Use: 5.90 Percent in Use: 34.54
207.*.*.* 8: Time Used: 11077.45 minutes Logins: 378 Percent of
Total Use: 4.38 Percent in Use: 25.64
207.*.*.* 9: Time Used: 10056.60 minutes Logins: 294 Percent of
Total Use: 3.98 Percent in Use: 23.28
207.*.*.* 10: Time Used: 8110.18 minutes Logins: 234 Percent of
Total Use: 3.21 Percent in Use: 18.77
207.*.*.* 11: Time Used: 5466.27 minutes Logins: 185 Percent of
Total Use: 2.16 Percent in Use: 12.65
207.*.*.* 12: Time Used: 4167.28 minutes Logins: 98 Percent of
Total Use: 1.65 Percent in Use: 9.65
207.*.*.* 13: Time Used: 3394.20 minutes Logins: 93 Percent of
Total Use: 1.34 Percent in Use: 7.86
207.*.*.* 14: Time Used: 2880.55 minutes Logins: 60 Percent of
Total Use: 1.14 Percent in Use: 6.67
207.*.*.* 15: Time Used: 1555.62 minutes Logins: 41 Percent of
Total Use: 0.62 Percent in Use: 3.60
207.*.*.* 16: Time Used: 955.50 minutes Logins: 17 Percent of Total
Use: 0.38 Percent in Use: 2.21
207.*.*.* 17: Time Used: 211.80 minutes Logins: 14 Percent of Total
Use: 0.08 Percent in Use: 0.49
207.*.*.* 18: Time Used: 374.62 minutes Logins: 8 Percent of Total
Use: 0.15 Percent in Use: 0.87
207.*.*.* 19: Time Used: 178.10 minutes Logins: 7 Percent of Total
Use: 0.07 Percent in Use: 0.41

------------------------------------------------------------

Customer Usage
------------------------------------------------------------

<SNIP> output same as raquick </SNIP>

------------------------------------------------------------

Customer Usage Summary
------------------------------------------------------------
Total number of Users: ***
Total Charges: $ ****.**
Total Time Used: 252826.57 minutes
4213.78 hours
Total Logins: 7175 logins
Percentage of System in use: 29.26
Average Hours monthly use per user: 37.96 hours
Average User Connect Time: 35.24 minutes/login
Logins per User: 64.6