Below, is a SQL script that I use to track down users, based on an IP
address and date/time of the alleged offense. Just put in the
date/time and IP address.
Josh Hillman
hillman@talstar.com
/* Username associated with IP address at specific point in time. */
/* If a STOP record (AcctStatusType=2) was not entered into the */
/* database by radius, this script will not work. */
SET NOCOUNT ON
DECLARE @datetime char(20)
DECLARE @IPAddress char(15)
SELECT @datetime = '7/3/99 11:29am'
SELECT @IPAddress = '192.168.2.3'
SELECT Username,
"Start Of Session" = DateAdd(Second, 0 - AcctSessionTime - AcctDelayTime, CallDate),
"End Of Session" = DateAdd(Second, 0 - AcctDelayTime, CallDate),
"Seconds" = AcctSessionTime,
"IP Address" = FramedAddress,
CallerID
FROM Calls
WHERE DateAdd(Second, 0 - AcctSessionTime - AcctDelayTime, CallDate) <= @datetime
AND DateAdd(Second, 0 - AcctDelayTime, CallDate) >= @datetime
AND FramedAddress = @IPAddress
AND AcctStatusType = 2
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart