RE: [Emerald] Users who have called

Robert H. Clugston ( (no email) )
Tue, 9 Mar 1999 12:27:56 -0800

Dale,
Close but I what names and a number where I can call them at. I'm going to
be calling users to have them change their access number.

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

"Robert H. Clugston" wrote:
>
> 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.

Try this:

Select Username, CallerID, count(*)
>From Calls
Where NASIdentifier='x.x.x.x'
Group By Username, CallerID

--

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