Josh Hillman wrote:
> From: Info Desk <firstname.lastname@example.org>
> >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. */
> 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,
> 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:
For more information about this list (including removal) go to: