Re: Wondering...
Dale E. Reed Jr. ( (no email) )
Mon, 28 Jul 1997 16:19:32 -0700
Warren Kipp wrote:
>
> The last month or so we've had one of our modems which is "hanging", "dead"
> etc., The modems are Hayes Century, and we found we had to do a reset of
> that particular modem.
>
> I was wondering if there was anyway (SQL or otherwise) that I could find out
> the last person to successfuly use that modem. We're wondering if it is
> caused by the remote users' equip.
>
> Even if my theory doesn't hold up, is there an SQL command or a report that
> would show the HISTORY of a particular modem's users?
You would probably want to look at the start records for this:
Select UserName, CallDate
From Calls
Where NASIdentifier = "x.x.x.x"
And NASPort = y
And CallDate > '7/28/97'
And AcctStatusType = 1
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com