------=_NextPart_000_0095_01BEDA74.8F2746D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
From: Chris Cover <ccover@signature-is.com>
> How is it possible to discover who was on at such-and-such
> time and such-and-such IP address?
In Emerald, click on the Online button, then check the "Search all calls"
option. Enter in the info there.
Or, use something like the SQL script I attached ("IP Address to
Username.sql").
Josh
------=_NextPart_000_0095_01BEDA74.8F2746D0
Content-Type: application/octet-stream;
name="IP Address to Username.sql"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="IP Address to Username.sql"
/* Username associated with IP address at specific point in time */
/* If a STOP record (AcctStatusType=3D2) 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 =3D '7/3/99 11:29am'
SELECT @IPAddress =3D '199.44.20.98'
SELECT Username,
"Start Of Session" =3D DateAdd(Second, 0 - AcctSessionTime - =
AcctDelayTime, CallDate),
"End Of Session" =3D DateAdd(Second, 0 - AcctDelayTime, =
CallDate),
"Seconds" =3D AcctSessionTime,
"IP Address" =3D FramedAddress,
CallerID
FROM Calls
WHERE DateAdd(Second, 0 - AcctSessionTime - AcctDelayTime, CallDate) =
<=3D @datetime
AND DateAdd(Second, 0 - AcctDelayTime, CallDate) >=3D @datetime
AND FramedAddress =3D @IPAddress
AND AcctStatusType =3D 2
------=_NextPart_000_0095_01BEDA74.8F2746D0--