My guess is that your "default" database is set to "master" instead of
"Emerald". In ISQL/w, make sure you change "master" to "Emerald" in the
"DB" section at the top of the window. I can't remember how you set Emerald
as the default database permanently--I did it ages ago.
Josh
*********** REPLY SEPARATOR ***********
On 7/8/99, at 12:19 PM, Josh Hillman wrote:
>From: Info Desk <info@olynet.com>
>>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
>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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart