Calls Consolidation Process

Robert H. Clugston ( (no email) )
Thu, 12 Nov 1998 11:34:15 -0800

Doesn't the Call Consolidation Process empty the calls table? It would be
nice to have logs back to the first of the year of who logged on when and

-----Original Message-----
[] On Behalf Of Dale E. Reed Jr.
Sent: Thursday, November 12, 1998 1:07 AM
Subject: Re: Script

Alan D. Criado wrote:
> Does anyone have a script that can show who was logged on to a particular
> IP Address within a range of time?
> One of my customers thought it would be nice to send out tons of spams and
> I need to find out who it was. The time and date stamp on his spam
> messages narrow it down as well as the IP address it said it came from.
> If anyone has a script that can pull this information, please let me know.

I use this one:

DECLARE @timeon smalldatetime, @timeon smalldatetime, @userip char(16)

Select @timeon = "11/9/96 16:00"
Select @timeoff = "11/9/96 22:00"
Select @userip = ""

Select UserName, Start=DateAdd(Second,
(0-AcctSessionTime-AcctDelayTime), CallDate), Mins=(AcctSessionTime/60),
Stop=DateAdd(Second, (0-AcctDelayTime), CallDate),
Server=SubString(Server, 1, 15), Port=Str(NASPort,4), IP=FramedAddress

from calls, servers
where DateAdd(Second, (0-AcctSessionTime-AcctDelayTime), CallDate) >=
and DateAdd(Second, (0-AcctDelayTime), CallDate) <= @timeoff
and AcctStatusType = 2
and calls.NASIdentifier=servers.ipaddress
and FramedAddress = @userip
Order By Start


--Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |

For more information about this list, including removal,please see