System Information - Status
Selecting the Status option in the left pane will display useful information about the current status of the DataSplice Server. There are four status tabs available:
- Connected Clients
- Current Sessions
- Worker Threads
- Database Handles
Connected Clients Tab
This displays the list of active client connections with the server. The following information is displayed:
| User Name | This shows the login name associated with the connection. This may be a name created just for DataSplice, or it may be part of an external domain. This name is created in the Users and Groups section.
|
|---|---|
| Status |
This displays any current activity of the connection, such as requesting data or updating a record. DataSplice displays any changes to this information immediately.
|
| Location |
This displays the network address (IP Address and Port) of the remote connection.
|
| Application |
This displays the application name and version of the DataSplice client being run by the user.
|
| Time Connected |
This displays the date and time when the remote connection was established.
|
| Idle |
This displays the length of time since the remote connection requested any information or performed an action against the DataSplice Server.
|
By right-clicking on a field in the grid, several actions can be performed:
- Write Client
- This will allow the administrator to send a message to the selected client.
- Write All
- This is similar to Write Client, except the message will be sent to all active connections.
- Disconnect Client
- This will close the selected connection. This can be used to disconnect users that have been idle for too long and free up licenses if needed.
Writing to a Client / Writing to All
To send a message to all users or a particular user:
- Right click on the user of interest in the tab.
- From the menu, select Write Client to send a message to that particular user or Write All to send a message to all users.
- The Enter Message dialog box appears.
- Enter the message exactly as it is to be viewed by the user(s).
- Click OK.
- The message will appear as a pop-up box to the particular user if you selected Write Client or to all users if you selected Write All.
Disconnecting a Client
To disconnect a user:
- Right click on the user of interest.
- Select Disconnect Client from the menu.
- The user will be removed from the Connected Clients list.
- An error message will appear as a pop-up box on the user's device, notifying them that the server has dropped the connection.
Current Sessions Tab
This displays a list of the current sessions on the server. This includes both online and offline sessions. The following information is listed:
| Session Name | This is the unique, server-generated name for the session, which is based off the user name and the time the session was created.
|
|---|---|
| User Name |
The login name of the user associated with the session.
|
| Time Created |
The date and time the session was initially created.
|
| Time Accessed |
The date and time of the last connection with the session.
|
| Duration |
The amount of time that has elapsed since the time of the last connection with the session.
|
| Session Type |
This indicates whether the session is Online or Offline.
|
By right-clicking a session, the administrator can choose Revoke Session to delete the session if desired. This can be used to free up the license for an orphaned session. Be careful, once a session has been revoked, the remote user will not be able to reconnect with the associated offline session and any uncommitted changes will be lost.
Worker Threads Tab
This displays information about the current worker threads on the server, which are used to process requests from remote clients. The following fields are displayed:
| Id | The identification number assigned by DataSplice to the worker thread.
|
|---|---|
| Status |
Displays the current activity of the thread. If the thread is not processing any request, it will display Idle.
|
| Duration |
Indicates how long the thread has been in its current state.
|
Database Handles Tab
This displays a list of all the connections to various databases the server currently has open. The following information is displayed:
| Data Source | This displays the ODBC DSN of the connection.
|
|---|---|
| User Name |
This shows the login name that was used to connect to the data source.
|
| Cursor Lib |
This indicates whether or not the ODBC Cursor Library is being used by the database handle.
|
| Recordsets |
This indicates how many recordsets are currently open through this database connection.
|
| In Use |
This field indicates if the connection is currently being used to communicate with the data source.
|