Re: [Emerald] Statistics

Dale E. Reed Jr. ( (no email) )
Wed, 01 Dec 1999 11:08:40 -0800

Emerald wrote:
>
> Dale (or anyone else who's good with sql)
>
> 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?

Try this (althought it doesn't do the percentage, it gives the numbers):

Select NASIdentifier, ConnectInfo, Count(*)