RE: [Emerald] Users who have called

Robert H. Clugston ( (no email) )
Tue, 9 Mar 1999 10:47:34 -0800

Dale,
Actually what I was original trying to do before I got side tracked was
print up a list of all the people who called a certain NAS along with their
phone number.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Monday, March 08, 1999 10:12 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] Users who have called

"Robert H. Clugston" wrote:
>
> List,
> I want to print up a list of all the people who have called my PM3's
in
> the past few months. Is this query look correct, because if so I'm showing
> that a lot of people aren't using my system.
>
> SELECT
> DISTINCT SubAccounts.LastName,
> SubAccounts.FirstName
> FROM
> emerald.dbo.Calls Calls INNER JOIN emerald.dbo.SubAccounts SubAccounts
ON
> Calls.AccountID = SubAccounts.AccountID

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



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