SessionId: String;
The SessionId property returns session identifier for the user connected to repository.
Add a link to the Metabase system assembly.
Sub UserProc;
Var
MB: IMetabase;
Users: IConnectedUsersInfoEx;
User: IConnectedUserInfoEx;
Begin
// Get repository
MB := MetabaseClass.Active;
// Get active users connected to repository
Users := MB.GetConnectedUsersEx;
// Display message in the console if connected users are missing
If Users.Count = 0 Then
Debug.WriteLine("No connected users");
Else
// Display information about each user in the console
For Each User In Users Do
// Display platform user name
Debug.WriteLine("DBMS user: " + User.UserName);
// Display OS user name
Debug.WriteLine("OS user: " + User.UserOsName);
// Display workstation name
Debug.WriteLine("Workstation: " + User.HostName);
// Display network MAC address of computer
Debug.WriteLine("Network MAC address of computer: " + User.NetAddress);
// Display user session identifier
Debug.WriteLine("Session ID: " + User.SessionId);
Debug.WriteLine("=========================================");
End For;
End If;
End Sub UserProc;
After executing the example the console displays information about each user: platform user name, OS user name, workstation name, network MAC address of computer and user session identifier. If there are no connected users, an appropriate message is displayed in the console.
The example of displaying information about connected users:
=========================================
DBMS user: ADMIN
OS user: petr.petrov
Workstation: PETROV
Network MAC address of computer: A0-E3-23-D5-E6-84
Session ID: 78
=========================================
DBMS user: ADMIN
OS user: ivan.ivanov
Workstation: IVANOV
Network MAC address of computer: AC-22-0B-C8-6A-C4
Session ID: 93
=========================================
See also: