Re: [Emerald] SQL Query for calls online

Brad Pritikin ( (no email) )
Tue, 11 Jul 2000 16:38:46 -0700

SELECT * From CallsOnline Where AcctStatusType = 1

Here is a list of possible fields:

NASIdentifier
NASPort
UserName
AcctStatusType
CallDate
FramedAddress

The NASIdentifier tells you which server they are dialed into.

Brad Pritikin - BradP@isat.com
Developer/Database Administrator
Internet Services And Technologies,
an Inforum Communications, Inc. Company

----- Original Message -----
From: Randy Martin <IEAEmerald@austintx.net>
To: <emerald@iea-software.com>
Sent: Tuesday, July 11, 2000 4:25 PM
Subject: [Emerald] SQL Query for calls online

> Can someone give me the SQL Query for the calls online function in
Emerald?
> I'm trying to add this function to some Cold Fusion pages I'm working on.
>
> Thanks,
> Randy
>
>
> 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