Re: Log File

Michael Whisenant ( mwhisen@airnet.net )
Wed, 23 Apr 1997 21:57:06 -0500

Now can you provide us with a quick and easy, If I know the IP and the date
and time can I get the username? I have written a CR report, but I have to
pull all instances of the IP that resides in the calls table, it sorts by
day, but I have to read through weeks to find the exact day. Seagate says
that CR has a problem with some of the pk_Constraints in Emerald????

At 11:33 AM 4/23/97 -0700, you wrote:
>Philip Thomas wrote:
>>
>> Dale or anyone, Where does emerald/radiusnt store its log file for its
>> users that dial-in. Specfically I need to find out what particualr ip
>> address was assigned at a particular time. I think RADIUS has this feature,
>> but with emerald I'm not sure. Phil
>
>Select * From Calls
> Where Username = "username"
> Order By CallDate DESC
>
>--
>Dale E. Reed Jr. (daler@iea.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.emerald.iea.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>