From Bright Pattern Documentation
Jump to: navigation, search
 
(Marked this version for translation)
 
(One intermediate revision by one other user not shown)
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.
  
Time is given in the Universal Coordinated Time (UTC) time zone, and the time is rounded to a minute.
+
<!--T:5-->
 +
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.
  
Time is given in the Universal Coordinated Time (UTC) time zone, and the time is rounded to a minute.
+
<!--T:7-->
 +
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.
 
|}
 
|}
Line 41: Line 47:
  
  
<center>[[reporting-database-specification/scenario_step_counters|< Previous]]  |  [[reporting-database-specification/GeneralInformationAboutDetailedRecords|Next >]]</center>
+
 
 
</translate>
 
</translate>

Latest revision as of 22:56, 16 August 2019

Other languages:
English • ‎日本語
• 5.2 • 5.3 • 5.8

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.


< Previous | Next >