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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |