Navigation:  Advantage SQL > System Procedures > Procedures >


Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Returns a result set containing all users currently connected to the server.


EXECUTE PROCEDURE sp_mgGetConnectedUsers()


UserName (O)

Name of the connected user.

ConnNumber (O)

NetWare connection number. (Deprecated)

DictionaryUser (O)

Name of user that has authenticated to an Advantage Data Dictionary.

Address (O)

IP or IPX address of the connected user.

OSUserLoginName (O)

Operating system login name of the connected user.

TSAddress (O)

Terminal Server Client IP address if the connection is made from a Terminal Server session.

ApplicationID (O)

Application ID for the connected user. See sp_SetApplicationID.

AverageCost (O)

The estimated average cost per server request for the connection. If this value is less than or equal to the current threshold (see sp_mgGetActivityInfo), the next request will be placed in the Express Queue.


sp_mgGetConnectedUsers returns the names of each connected user. UserName will be the name of the computer the user is connected from.  OSUserLoginName will be the operating system user name of the user. DictionaryUser will be the data dictionary user name if the user is authenticated to a data dictionary.


Note With Advantage Local Server, sp_mgGetConnectedUses will only return information about users of the instance of Advantage Local Server currently loaded into memory. Information about users from other instances of the Advantage Local Server will not be returned.



EXECUTE PROCEDURE sp_mgGetConnectedUsers();

See Also