I've been trying to write a script to do the below but I'm about to give up
so I thought I would ask here to see if anyone here is good enough at sql to
do this.
Using calls table, I want to create a report that shows the % of calls that
connected with each of the different connect speeds shown in connectinfo and
group it by nasidentifier so basically it would look something like this
111.111.111.111 1200 LAPM/V42BIS 1%
12000 LAPM/NONE 3%
26400 LAPM/V42BIS 22%
222.222.222.222 1200 LAPM/V42BIS 1%
12000 LAPM/NONE 3%
26400 LAPM/V42BIS 22%
So I can see what connect rates are most common on which dialup boxes. The %
numbers would be based on the total number of calls for that nasidentifier.
So if there were 100 calls to that dialup box then 22 of them would have
been 26400 LAPM/V42BIS, etc.
Anyone feel up to the challenge?
Geo.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart