Re: [Emerald] Users who have called

Dale E. Reed Jr. ( (no email) )
Mon, 08 Mar 1999 22:54:09 -0800

"Ronnie D. Franklin" wrote:
>
> Is the results that this returns the number of times a username has logged
> in since Calls was updated.... or is it the total number of logins in the
> calls table???

Its the total, including start and stop records.

> > This is only correct AFTER you have done a calls update in the
> > Emerald Admin. A better/faster query would be:
> >
> > Select Username, count(*)
> > From Calls
> > Group By Username
> > Order By count(*) DESC
> 

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html