IMetabase.GetConnectedUsersEx

Syntax

GetConnectedUsersEx: IConnectedUsersInfoEx;

Description

The GetConnectedUsersEx method gets information about active users connected to the repository.

Comments

The method is an extended version of the GetConnectedUsers method and can be used when working in all supported DBMS, except for SQLite.

Example

Add a link to the Metabase system assembly.

Sub UserProc;
Var
    MB: IMetabase;
    Users: IConnectedUsersInfoEx;
    User: IConnectedUserInfoEx;
Begin
    MB := MetabaseClass.Active;
    Users := MB.GetConnectedUsersEx;
    For Each User In Users Do
        Debug.WriteLine("Workstation: " + User.HostName + "; MAC address: " + User.NETAddress);
        Debug.WriteLine("DBMS user: " + User.UserName + "; OS user: " + User.UserOsName);
    End For;
End Sub UserProc;

After executing the example the development environment console displays information about all users connected to the current repository.