sp_mgGetConnectedUsers

Advantage SQL Engine

  Previous topic Next topic  

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.

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

The UserName can be either the Computer Name or the NetWare connection name of the connected user. The ConnNumber is the NetWare connection number of the connected user; this only applies to Advantage Database Server for NetWare.

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