(Marked this version for translation) |
|||
| Line 1: | Line 1: | ||
| − | <translate>= concurrent_users= | + | <translate>= concurrent_users= <!--T:1--> |
The ''concurrent_users'' table tracks the number of users that were using the system at any moment in the past. A new row is added every time when a number of logged in users changes from a non-zero value (i.e., when a non-first user logs in or any user logs out), but not 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 [[contact-center-administrator-guide/ReportingSettings|Reset time for daily statistics]]. | The ''concurrent_users'' table tracks the number of users that were using the system at any moment in the past. A new row is added every time when a number of logged in users changes from a non-zero value (i.e., when a non-first user logs in or any user logs out), but not 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 [[contact-center-administrator-guide/ReportingSettings|Reset time for daily statistics]]. | ||
| − | == Description of Data == | + | == Description of Data == <!--T:2--> |
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. | 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. | ||
| + | <!--T:3--> | ||
{|border="1" style="border-collapse:collapse" cellpadding="5" | {|border="1" style="border-collapse:collapse" cellpadding="5" | ||
|'''Column Name''' | |'''Column Name''' | ||
| Line 20: | Line 21: | ||
|This is a list of usernames of users that were logged into the system in the interval specified by ''start_time'' and ''end_time''. | |This is a list of usernames of users that were logged into the system in the interval specified by ''start_time'' and ''end_time''. | ||
| + | <!--T:4--> | ||
Users are specified as JSON array of ''[username1, username2, … usernameN]'' where ''N = num_users''. | Users are specified as JSON array of ''[username1, username2, … usernameN]'' where ''N = num_users''. | ||
|- | |- | ||
| Line 26: | Line 28: | ||
|Start time of the interval for which the ''num_users'' and ''users'' data in this record remains valid. | |Start time of the interval for which the ''num_users'' and ''users'' data in this record remains valid. | ||
| + | <!--T:5--> | ||
Time is given in Universal Coordinated Time (UTC), and the time is rounded to a minute. | Time is given in Universal Coordinated Time (UTC), and the time is rounded to a minute. | ||
| + | <!--T:6--> | ||
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. | 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. | ||
|- | |- | ||
| Line 34: | Line 38: | ||
|End time of the interval for which the ''num_users'' and ''users'' data in this record remains valid. | |End time of the interval for which the ''num_users'' and ''users'' data in this record remains valid. | ||
| + | <!--T:7--> | ||
Time is given in Universal Coordinated Time (UTC), and the time is rounded to a minute. | Time is given in Universal Coordinated Time (UTC), and the time is rounded to a minute. | ||
| + | <!--T:8--> | ||
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. | 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. | ||
|} | |} | ||
Revision as of 22:56, 16 August 2019
<translate>= concurrent_users= The concurrent_users table tracks the number of users that were using the system at any moment in the past. A new row is added every time when a number of logged in users changes from a non-zero value (i.e., when a non-first user logs in or any user logs out), but not 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 |
| 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. |
</translate>