Re: [Emerald] Statistics

Donn Lasher ( dlasher@bossig.com )
Wed, 01 Dec 1999 12:57:15 -0800

Didn't quite think this was what you intended:

NASIdentifier Speed
---------------- ----------- -----------
127.0.0.1 NULL 64
199.79.131.219 NULL 24118
199.79.131.70 NULL 56713
199.79.131.72 NULL 57641

etc etc etc

At 12:27 PM 12/1/99 -0800, you wrote:
>Emerald wrote:
> >
> > > Try this (althought it doesn't do the percentage, it gives the numbers):
> > >
> > > Select NASIdentifier, ConnectInfo, Count(*)
> > > From Calls
> > > Group By NASIdentifier, ConnectInfo
> > > Order By NASIdentifier, ConnectInfo
> >
> > Close, very close to what I need. Is there a way to have it group by just
> > the left 5 characters of the connectinfo field though? What I'm getting is
> > this:
> >
> > 28800 LAPM/MNP5
> > 28800 LAPM/NONE
> > 28800 LAPM/V42BIS
> > 28800 MNP/NONE
> >
> > but I would like to see these as all one group (I only care about the
> > speed).
>
>Maybe something like:
>
>Select NASIdentifier, Speed=convert(int,ConnectInfo), Count(*)
> From Calls
>Group By NASIdentifier, convert(int,ConnectInfo)
>Order By NASIdentifier, convert(int,ConnectInfo)
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart