Re: [RadiusNT] IP usage logging

Dale E. Reed Jr. ( (no email) )
Wed, 03 Nov 1999 09:52:11 -0800

"Carlos Diaz, System Eng." wrote:
>
> Do you have any statement to select that data from the database?

If you are using Emerald, from the Calls online screen, select the
search option and you can enter a date range and IP address. Otherwise,
you have to use an SQL Statement like below. This shows who has that
IP in that time frame.

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

Select @timeon = "11/1/99 16:00"
Select @timeoff = "11/1/99 22:00"
Select @userip = "1.2.3.4"

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. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart