RE: [Emerald] Users who have called

Ronnie D. Franklin ( ronnie@itexas.net )
Tue, 9 Mar 1999 00:37:39 -0600

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???

>
> 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

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