Re: [Emerald] not seeing users in the on-line tab

Charles Weidner ( (no email) )
Thu, 5 Aug 1999 11:02:52 -0700

This is a multi-part message in MIME format.

------=_NextPart_000_0252_01BEDF32.106BED60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What type of terminal servers are you running. Are they ported =
correctly. If Emerald cannot find port numbers for the users that are =
logging in it will collect the data but not display it in your calls =
online.

Correct me if I'm wrong Dale but I belive the easiest way to fix this =
problem is to run this script that will popilate your serverports tabel =
based on the ports that have been logged as incoming

/* Run the following script in isql_w against your Emerald database
and see if it fills in any missing ports for the server ports. If
the server is not ported correctly (some are missing) then the users
will not show up on-line if they call a port that isn't listed. Their
call WILL be logged, they just don't show up on-line. This script
will add any missing ports that have been logged by your terminal
server.
You might run it a couple of times (once a month) until it gets all
your ports. */

/* Update Ports */

DECLARE @nasid varchar(16), @nasport int, @msg varchar(255), @serverid =
int

DECLARE ub_cursor CURSOR FOR=20
Select NASIdentifier, NASPort