concurrent_users
The concurrent_users table tracks the number of users that were using the system at any moment in the past. The table segments agents and mobile users from the total count by their privileges. A new entry is added to the table whenever there is a change in the number of logged-in users from a non-zero value. This occurs, for instance, when a new user logs in while another user is already logged in, or when any user logs out. However, these entries are not added more frequently than once a minute. (After a first login/logout within a given minute, all subsequent logins/logouts that happen within that same minute will be aggregated and written as a single record one minute after.) A new record is also created unconditionally at the configured Reset time for daily statistics.
Description of Data
The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHAR, etc.), and description for each metric (i.e., column) of the concurrent_users table.
| Column Name | Data Type | Description |
| num_users | INT | Number of users that were logged into the system in the interval specified by start_time and end_time |
| concurrent_agent_users | INT | Number of users who have Handle automatically distributed interactions, Handle Email and Cases, or Handle service chats privilege. |
| concurrent_mobile_users | INT | Number of users who have the Login to mobile user app privilege. |
| concurrent_agent_mobile_users | INT | The number of users who have both Login to mobile user app and Handle automatically distributed interactions privileges. |
| users | JSON array | This is a list of usernames of users that were logged into the system in the interval specified by start_time and end_time.
Users are specified as JSON array of [username1, username2, … usernameN] where N = num_users. |
| start_time | TIMESTAMP | Start time of the interval for which the num_users and users data in this record remains valid.
Time is given in Universal Coordinated Time (UTC), and the time is rounded to a minute. Note that it is normal for this time to differ by a few seconds from the time of state changes reported in the agent_activity table. |
| end_time | TIMESTAMP | End time of the interval for which the num_users and users data in this record remains valid.
Time is given in Universal Coordinated Time (UTC), and the time is rounded to a minute. Note that it is normal for this time to differ by a few seconds from the time of state changes reported in the agent_activity table. |