Re: [Emerald] Netbus

Josh Hillman ( (no email) )
Thu, 8 Jul 1999 12:19:19 -0400

From: Info Desk <>
>I know this was at one time a hot topic. Does anyone have a report that
>shows who is logged onto what IP on any certain day and time? I need to
>catch a couple of people being minor problems.

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

/* 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. */

DECLARE @datetime char(20)
DECLARE @IPAddress char(15)

SELECT @datetime = '7/3/99 11:29am'
SELECT @IPAddress = ''

SELECT Username,
"Start Of Session" = DateAdd(Second, 0 - AcctSessionTime - AcctDelayTime, CallDate),
"End Of Session" = DateAdd(Second, 0 - AcctDelayTime, CallDate),
"Seconds" = AcctSessionTime,
"IP Address" = FramedAddress,
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: