Calls Consolidation Process

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

Dale,
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
where.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.
Sent: Thursday, November 12, 1998 1:07 AM
To: emerald@iea-software.com
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 = "204.227.164.2"

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) >=
@timeon
and DateAdd(Second, (0-AcctDelayTime), CallDate) <= @timeoff
and AcctStatusType = 2
and calls.NASIdentifier=servers.ipaddress
and FramedAddress = @userip
Order By Start

GO

--Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html