sp_mgGetConnectedUsers

Advantage SQL Engine

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.

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