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