Navigation:  Advantage SQL > System Procedures > Procedures >

sp_mgGetConnectedUsers

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

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

Syntax

EXECUTE PROCEDURE sp_mgGetConnectedUsers()

Parameters

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.

Remarks

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.

 

Example

EXECUTE PROCEDURE sp_mgGetConnectedUsers();

See Also

sp_mgGetTableUsers

sp_mgGetUserIndexes

sp_mgGetUserLocks

sp_mgGetUserTables