RE: [Emerald] Calls not being cleared

Malcolm Joosse ( (no email) )
Fri, 1 Oct 1999 08:56:37 +1000

Thank you for the info,
Now I am waiting for the MAX to reboot so I can try the script.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Friday, 1 October 1999 3:11
To: emerald@iea-software.com
Subject: Re: [Emerald] Calls not being cleared

PowerNet wrote:
>
> Here is the SQL command we use to clear the calls online table and it
works great.
> Sure saves clicking clear for each user.
>
> update serverports set username = NULL

Actually, use this:

Update ServerPorts
Set AcctStatusType = 0

They look at the AST field to determine online, not username. Its just
the Emerald filters our the "NULL" user names, but RadiusNT doesn't.

--

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

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