Re: [Emerald] Netbus

PowerNet ( (no email) )
Tue, 20 Jul 1999 08:29:35 -0400


I tried running this script and got the result

Msg 208, Level 16, State 1
Invalid object name 'Calls'

Any ideas?


*********** REPLY SEPARATOR ***********

On 7/8/99, at 12:19 PM, Josh Hillman wrote:

>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=3D2) was not entered into the */
>/* database by radius, this script will not work. */
>DECLARE @datetime char(20)
>DECLARE @IPAddress char(15)
>SELECT @datetime =3D '7/3/99 11:29am'
>SELECT @IPAddress =3D ''
>SELECT Username,
> "Start Of Session" =3D DateAdd(Second, 0 - AcctSessionTime -=
AcctDelayTime, CallDate),
> "End Of Session" =3D DateAdd(Second, 0 - AcctDelayTime,=
> "Seconds" =3D AcctSessionTime,
> "IP Address" =3D FramedAddress,
> CallerID
>FROM Calls
>WHERE DateAdd(Second, 0 - AcctSessionTime - AcctDelayTime, CallDate) <=3D=
>AND DateAdd(Second, 0 - AcctDelayTime, CallDate) >=3D @datetime
>AND FramedAddress =3D @IPAddress
>AND AcctStatusType =3D 2
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: