You can use Data Export to track a wide variety of statistics, Session activities, and more. You can learn how to run a Data Export job here. Choose a Data Export View below to see the information included in the export; click each heading to expand.




User_Info



This table contains information pertaining to all your Users, including Admins, Designers, Agents, etc. (click to expand)
user_id
Unique User ID in Support.com (Primary Key).
email
User email.
given_name
User first name.
family_name
User last name.
phone
User phone number.
time_created
Date and time the User was created.
time_deleted
Date and time the User was deleted. When you delete a User, that User no longer appears in the UI, but the User's information can still be retrieved via Data Export.
time_accessed
Date and time User last logged in.
is_global
Internal use
global_user_id
Internal use
external_id
User ID in an external system.
teams
Teams the User is on. Information is returned as a JSON array with the following format:
[ { "id": 0, "name": "string", "description": "string" } ]
roles
Roles the User is assigned. Information is returned as a JSON array with the following format:
[ { "id": 0, "name": "string", "description": "string" } ]
skills
Skill the User is assigned. Information is returned as a JSON array with the following format:
[ { "id": 0, "name": "string", "description": "string" } ]



User_Login_Activity



This activity view lists Agents that were active between a start time and an end time you specify. (click to expand) 


id
One specific record of User login/logout activity. (Primary Key)
agent_id
Agent ID. (Foreign Key)
agent_given_name
User first name.
agent_family_name
User last name.
login_time_stamp
Login time.
latest_activity_time
Time of most recent User activity (not necessarily login/logout.)
logout_time_stamp
Logout time (this may be blank if the User did not explicitly log out.)
ip_address
User IP Address.
os
User operating system information.
browser
User browser information.



Session_Assignment_Activity



This activity view lists Session assignments and other actions between a start time and an end time you specify.





Id
Unique ID for each specific Agent action (e.g. Assignment, Reskill, Transfer.) (Primary Key)
session_id
Session ID. (Foreign Key)
start_time
Assignment start time.
end_time
Assignment end time (due to removal or end of active work.)
reason_code
Reason for a Session being assigned to a queue. Reason codes include:


  • Session_Creation : Initial Session creation and queue assignment.
  • Session_Reskill : Session transferred to a different skill.
  • Session_Transfer: Session transferred to another Agent.
  • Session_Assign_To_Me : Session chosen by an Agent directly.
triggered_by
ID of the Agent who assigned the Session to the queue.
time_created
Date and time of the assignment.
pending_assignment
This field contains True if the Session is in queue and there is no Agent assigned.
session_external_id
Session ID in an external system.
session_device_type
Consumer device type (e.g. computer, mobile, other.)
agent_id
Assigned Agent ID.
agent_email
Agent email.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.



Session_Daily_Activity



This activity view tracks events that occurred in a Session on a given day.

 

id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
date
Date the first Session event occurred.
start_time
Time Session started.
latest_activity_time
Time of the last activity on this Session on this day.
latest_activity_event
Last event on this Session on this day.
latest_session_start_time
 
latest_session_view_time
 
is_status_set_closed
This field contains True if the Session was closed on this day, unless the Session was reopened.
is_created
This field contains True if the Session was created on this day.
reopen_count
Number of times the Session status changed from “closed” to “open” on this day.
attended_duration
Average handle time for the day for this Agent on this session. (in seconds)
view_duration
Sum of session_view and session_view_pause. (in seconds)
note_count
Number of times a note was created.
attachment_count
Number of attachments.
survey_sent_time
Time when a survey was sent to the Consumer.
survey_presented_time
Time when the Consumer viewed the survey.
survey_responded_time
Time when the Consumer submitted the survey.
created_device_count
Number of devices attached to this session on this day.
session_open_count
Number of times the Session status changed to "open" during this day. (including session creation)
session_close_count
Number of times the Session status changed to  "closed" during this day.
used_seesupport
This field contains True if the Agent used SeeSupport.
session_external_id
Session ID in an external system.
session_device_type
Device type. (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.
disposition
Session disposition. (Resolved/Unresolved)



Session_Device_Activity



A Session can be used to service multiple devices. This activity view has a row for each device that was worked on in a Session.
id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID. (Foreign Key)
session_device_id
Device ID.
start_time
Date and time of first Session activity.
is_created
This field contains True if the Agent created the Session. This field contains false otherwise. (e.g. the Session was created as part of Self-Service)
is_cancelled
This field contains True if the Agent cancelled out of the “Add Path” UI.
addpath_end_time
Date and time Agent either chose a Path or cancelled out of the “Add Path” UI.
addpath_duration
Time spent by Agent in the “Add Path” UI, regardless of whether Agent chose a Path. (in seconds)
first_device_start_time
 Date and time the first activity was received from the device.
latest_device_activity_time
Date and time the latest activity was received from the device.
latest_activity_time
Date and time of the latest Session activity.
latest_activity_event
Latest Session activity event.
working_as_assigned_user_since
 
latest_session_pause_time
 Date and time of the latest Session pause.
latest_device_start_time
 Date and time the most recent event was received from the device.
attempt_connect_duration
Time the Agent spent on the connection screen. (in seconds)
attended_duration
Time the Agent spent on this device. (in seconds)
is_email_link_sent
This field contains True if an email with app installation instructions was sent to the Consumer.
is_sms_link_sent
This field contains True if an SMS with app installation instructions was sent to the Consumer.
is_connection_guide_opened
This field contains True if the Agent viewed the Connection Guide to assist the Consumer with installation of the app.
remote_pushed_url_count
Number of times Agent invoked push URL to send a URL to the Consumer.
remote_pushed_url
Array of URLs pushed to the Consumer.
remote_view_zoomin_count
Not currently used.
remote_view_zoomout_count
Not currently used.
remote_win_start_count
Number of times the Agent sent Windows start shortcut to the Consumer’s machine.
remote_ctrl_alt_delete_count
Number of times The Agent sent Ctrl+Alt+Del to the Consumer’s machine.
latest_remote_connect_time
Date and time of the most recent device connection.
first_remote_connect_time
Date and time of the first device connection.
remote_connection_duration
Time spent remotely connected. (in seconds)
current_remote_connection_duration
In the case of multiple remote connections across one or more days, this field tells the time spent remotely connected in the currently running Session.
remote_disconnect_reason_code
Reason for disconnection. Reason codes include:

  • REBOOT -  Device gets rebooted
  • SESSION_CLOSE - Session was closed
  • LOG_OFF - Agent logged off
  • AGENT - Agent aborted the remote session
  • UNKNOWN - Unknown reason of calling network Shutdown
  • ERROR - Web socket error
  • USER - Customer disconnected
** first_path_start_time
Date and time the first Path started.
path_create_count
Number of Guided Paths the Agent chose while servicing this device in this Session.
path_start_count
Number of times the Agent started Guided Paths while servicing this device in this Session.
path_complete_count
Number of Guided Paths the Agent completed while servicing this device in this Session.
path_abort_count
Number of Guided Paths the Agent aborted while servicing this device in this Session.
is_session_status_closed
This field contains True if the Session was closed (unless subsequently reopened) or archived.
is_customer_remote_ready
This field contains True if the Consumer device is ready to be connected.
used_seesupport
This field contains True if the Agent sent a SeeSupport request to Consumer.
seesupport_duration
Time SeeSupport was used by the Agent. (in seconds)
seesupport_annotation_count
Number of times Agent used annotation in SeeSupport.
remote_annotation_count
Number of times Agent used annotation in Remote Control.
session_external_id
Session ID in an external system.
session_device_type
Device type (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.
remote_seesupport_accept_count
Number of times the Consumer accepted SeeSupport request.
remote_seesupport_decline_count
Number of times the Consumer declined SeeSupport request.
remote_camerafeed_pause_count
Number of times Agent paused the SeeSupport feed.
seesupport_pause_duration
Time SeeSupport feed was paused. (in seconds)
flashilight_used_count
Number of times Agent activated device flashlight.
remote_seesupport_zoom_in_count
Number of times Agent zoomed in.
remote_seesupport_zoom_out_count
Number of times Agent zoomed out.
os
Consumer device operating system information.
seesupport_mms_recv_count
Number of MMS received.
seesupport_mms_sent_count
Number of MMS sent.
seesupport_mms_history_panel_count
Number of times Agent expanded the history view.



Session_Path_Activity



This activity view displays information regarding a specific Session + Path combination.


id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
session_device_id
Device ID.
session_path_id
Instance ID of a device interaction.
path_version_id
Instance ID of the Path being executed.
is_created
This field contains True if the Agent is the Path creator.
start_time
Date and time workflow execution started.
end_time
Date and time workflow execution ended. (e.g. completed, aborted, paused)
is_aborted
This field contains True if the Path was aborted.
latest_path_activity_time
Date and time of the latest activity on the Path.
latest_activity_time
Date and time of the latest activity on this Session or for the Agent.
latest_activity_event
Latest activity event received on the Session or for the Agent.
working_as_assigned_user_since
 
latest_session_pause_time
 Date and time of the latest Session pause.
latest_device_pause_time
 Date and time of the latest device pause.
latest_path_start_time
 Date and time the most recent Path was started.
attended_duration
Time spent on the Session Path. (in seconds)
view_duration
Time spent viewing the Session. (in seconds)
expand_count
 
collapse_count
 
step_complete_count
Number of Steps the Agent completed.
step_na_count
Number of Steps the Agent marked "N/A."
step_blank_count
Number of Steps the Agent did not mark resolved. (e.g. completed, N/A)
attended_step_duration
Time spent working on all Steps on the Path. (in seconds)
unattended_step_duration
 
is_session_status_closed
 This field contains True if Session status is marked as "closed."
agent_id
Agent ID.
agent_email
Agent email.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.
session_external_id
Session ID in an external system.
path_id
Guided Path ID.
category_id
Category ID.



Session_Path_Step_Activity



This activity view displays information regarding a specific Step in a Path.
id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
session_device_id
Device ID.
session_path_id
ID for each Session+Path combination.
session_path_step_id
ID for each Session+Path+Step combination.
path_version_step_id
ID of the Path and Step version.

start_time
Date and time Step execution started.
end_time
Date and time Step execution ended.
latest_path_step_activity_time
Date and time the latest activity occurred on the Path+Step.
latest_activity_time
Date and time the latest activity occurred on the Session while the Agent is working on the Step.
latest_activity_event
Latest event that occurred on the Session while the Agent is working on the Step.
working_as_assigned_user_since
 
latest_session_pause_time
 Date and time of the latest Session pause.
latest_device_pause_time
 Date and time of the latest Device pause.
latest_path_pause_time
 Date and time of the latest Path pause.
latest_path_step_start_time
 
attended_duration
Time spent working on the Path+Step by the Agent. (in seconds)
view_duration
Time spent viewing the Path+Step. (in seconds)
status
The status the Agent marked on the Step. Statuses include:

  • IN_PROGRESS
  • COMPLETE
  • NOT_APPLICABLE
  • RESOLVED
  • ABORTED
step_name
Step name.
language_code
Step language code.
visit_sequence
An array of integers which represent the visit sequence of the Step. The number starts at “1”.
Each time a Step is visited, the number is incremented by 1.
session_external_id
Session ID in an external system.
session_device_type
Device type. (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.



Session_Queue_Activity



This activity view tracks events that occurred on a Session while it was in a queue.
id
 Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
skill_id
Skill to which the Session was queued.
start_time
Date and time the Session entered queue.
offer_time
Date and time the Session was offered to an available Agent.
offer_to
Agent to which the Session was offered.
end_time
Time at which the offer was removed. (end_time - start_time will tell the amount of time this session spent in the queue)
end_reason_code
Reason the offer was removed. Reason codes include:
  • SESSION_ASSIGNMENT_ACCEPTED
  • SESSION_ASSIGNMENT_REJECTED
  • SESSION_ASSIGNMENT_OFFER_TIMED_OUT
  • SESSION_ASSIGNMENT_OFFER_EXPIRED
  • SESSION_REQUEUED
  • SESSION_HARD_ASSIGN
  • UNKNOWN
end_by
Agent that took the action listed in end_reason_code.
triggered_by
Agent involved in queuing this session, if any.
session_external_id
Session ID in an external system.
session_device_type
Device type. (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.



Session_Path_Feedback



This view displays Agent feedback of a Path, as well as information regarding the feedback creation.
session_path_id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
time_start
Date and time when feedback activity started.
feedback_comments
Comments/Feedback provided by the Agent.
feedback_comments_archived
Array of feedback comments archived by Designers.
path_version_id
Guided Path ID.
path_name
Guided Path name.
path_audience
Intended Guided Path audience. (e.g. Agents, Consumers, both)
session_external_id
Session ID in an external system.
session_device_type
Device type. (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.
category_name
Category name.
category_id
Category ID.



Session_Survey



This view displays Survey responses generated by Agents.
agent_id
Agent ID. (Primary Key)
agent_email
Agent email.
session_id
Session ID. (Foreign Key)
question_name
Question text.
answer
Answer text.
time_created
Date and time the answer was received.



SelfService_Session_Daily_Activity



This activity view tracks events that occurred on a Self-Service Session on a given day.
id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
date
Session date. (tenant time zone)
start_time
Session start time.
latest_activity_time
Time of the latest activity associated with the Session.
latest_activity_event
Latest activity event received on the Session.
latest_session_start_time
Latest time a Session started
attended_duration
Time spent on the Session. (in seconds)
is_assisted
This field contains True if the Session is escalated to an Agent.
session_external_id
Session ID in an external system.
session_device_type
Device type. (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.



SelfService_Session_Path_Activity



This activity view displays information regarding a specific Self-Service Session+Path combination.
id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
session_device_id
Instance ID of a device interaction.
session_path_id
Instance ID of the Path being executed.
path_version_id
Guided path version ID.
start_time
Date and time Path execution started.
end_time
Date and time Path execution ended.
latest_path_activity_time
Date and time of latest activity associated with the Path.
latest_activity_time
Date and time of the latest activity either on this Session or for the Agent.
latest_activity_event
Latest activity event associated with the Session.
latest_session_pause_time
Date and time Agent paused work on the Session.
latest_path_start_time
Date and time Path was started/restarted.
attended_duration
Time spent working on the Session. (in seconds)
step_helpful_count
Number of Steps marked "helpful."
step_not_helpful_count
Number of Steps marked "not helpful."
step_blank_count
Number of Steps not marked as "helpful" or "not helpful."
attended_step_duration
Time spent working on the Step (in seconds)
rating
Rating given by the Consumer to the workflow.
session_external_id
Session ID in an external system.
session_device_type
Device type. (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
agent_given_name
Agent first name.
agent_family_name
Agent last name.
agent_external_id
Agent ID in an external system.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.
path_id
Guided Path ID.
category_id
Category ID



SelfService_Session_Path_Step_Activity



This activity view displays information regarding a specific Self-Service Step in a Path.
id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
session_device_id
Device ID.
session_path_id
Unique ID for each Session+Path combination
session_path_step_id
Unique ID for each Path+Step combination.
path_version_step_id
ID representing the Step version.
start_time
Date and time Step execution started.
end_time
Date and time Step execution ended.
attended_duration
Time Agent worked on the Step. (in seconds)
status
Session status.
was_assisted
This field contains True if the Session was escalated.
session_external_id
Session ID in an external system.
session_device_type
Device type (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
agent_given_name
Agent first name.
agent_family_name
Agent last name.
agent_external_id
Agent ID in an external system.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.



SelfService_Session_Device_Activity



A Session can be used to service multiple devices. This activity view has a row for each device that was worked on in a Self-Service Session.
id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
addpath_id
Guided Path ID.
session_device_id
Device ID.
start_time
Date and time of first Session activity.
first_device_start_time
Date and time the first event was received from the device.
latest_device_activity_time
Date and time the latest event was received from the device.
latest_activity_time
Date and time of the latest Session activity.
latest_activity_event
Latest activity event.
latest_session_pause_time
Latest session pause time.
latest_device_start_time
Latest device start time.
path_create_count
Number of times a Path is created under the device.
path_start_count
Number of times a Path is started under the device.
session_external_id
Session ID in an external system.
session_device_type
Device type. (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
agent_given_name
Agent first name.
agent_family_name
Agent last name.
agent_external_id
Agent ID in an external system.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.



SelfService_Session_Queue_Activity



This activity view tracks events on that occurred on a Session while it was in a queue.
id
Unique ID for each row in this view. (Primary Key)
session_id
Session ID.
escalation_time
Date and time Session was escalated to enter a queue.
start_time
Date and time Session entered queue.
start_reason_code
How the Session was escalated. Reason codes include:

  • From Client
  • Timeout
offer_time
Date and time Session was offered to an Agent.
offer_to
Agent to which the Session was offered.
end_time
Date and time offer was removed.

end_reason_code
Reason the offer was removed. Reason codes include:

  • SESSION_ASSIGNMENT_ACCEPTED
  • SESSION_ASSIGNMENT_REJECTED
  • SESSION_ASSIGNMENT_OFFER_TIMED_OUT
  • SESSION_ASSIGNMENT_OFFER_EXPIRED
  • SESSION_REQUEUED
  • SESSION_HARD_ASSIGN
  • UNKNOWN
end_by
Agent that took the action listed in end_reason_code.
consumer_abandoned_time
Date and time Consumer abandoned the session before it was picked by an Agent.
session_external_id
Session ID in an external system.
session_device_type
Device type. (e.g. computer, mobile, other)
agent_id
Agent ID.
agent_email
Agent email.
agent_given_name
Agent first name.
agent_family_name
Agent last name.
agent_external_id
Agent ID in an external system.
consumer_id
Consumer ID.
consumer_external_id
Consumer ID in an external system.
session_skill
Skill associated with the Session.



SelfService_Session_Queue_Statistics



This view displays statistical information regarding a Session that entered a queue.
session_id
Session ID. (Primary Key)
skill_id
Skill to which the Session was queued.
session_status
Session status.
queue_enter_time
Date and time the Session was escalated and entered the queue.
total_time_spent_in_queue
Time the Session statyed in queue. (in seconds)
end_time
Time Agent accepted the Session if end_reason_code is other than "SESSION_REQUEUED".

Time the Session re-queued if end_reason_code= "SESSION_REQUEUED" .
end_reason_code
Reason for assigning the Session.
accepted_agent_id
Agent ID. (Foreign Key)
accepted_agent_email
Agent email.
session_external_id
Session ID in an external system.
consumer_id
Consumer ID.
consumer_abandoned_time
Date and time Consumer abandoned the Session before it was picked up by an Agent.
chat_picked_time
Time Agent first enters Chat.
chat_end_time
Time Agent closed the Session or the Consumer closed Chat.
total_chat_time
Chat duration. (in seconds)



SelfService_Aggregate_Statistics



This view displays counts of outcomes of Self-Service Sessions.
total_selfservice_sessions
Number of sessions that used Self-Service.
distinct_call_escalation_count
Number of distinct sessions escalated using call.
total_call_escalation_count
Number of escalations using call.
distinct_chat_escalation_count
Number of distinct Sessions escalated using Chat.
total_chat_escalation_count
Number of escalations using Chat.
sessions_with_agent_presence
Self-Service Sessions where Agent assignment occurred.
distinct_selfservice_escalations
Number of distinct Sessions escalated using either Chat or call.
total_selfservice_escalations
Number of escalations using either Chat or call.



SeeSupport_Aggregate_Statistics



This view displays counts of outcomes of SeeSupport Sessions.
seesupport_session_count
Number of Sessions that used SeeSupport.
ios_seesupport_session_count
Number of SeeSupport Sessions with iOS devices.
android_seesupport_session_count
Number of SeeSupport Sessions with android devices.
annotation_session_count
Number of SeeSupport Sessions that used annotation.
screenshare_in_seesupport_count
Number of Sessions that used both screenshare & SeeSupport.
app_background_session_count
Number of Sessions where app was taken to the background.
framerate_changed_session_count
Number of SeeSupport sessions where framerate was modified.
flashlight_session_count
Number of SeeSupport Sessions where flashlight was used.
seesupport_zoom_session_count
Number of SeeSupport Sessions where zoom was used.
email_link_sent_count
Number of Sessions email containing a link to the app was sent to the Consumer.
sms_link_sent_count
Number of times where SMS containing a link to the app was sent to the Consumer.
total_seesupport_time
Time SeeSupport streaming was used (in seconds).
seesupport_mms_session_count
Number of Sessions where MMS feature was used.
seesupport_mms_images_received_session_count
Number of Sessions where image/s were received.
seesupport_mms_images_sent_session_count
Number of Sessions where Agent sent image/s.
seesupport_chathistory_used_session_count
Number of Sessions where the Chat history pane was expanded.



Path_Category



This view displays Guided Path metadata.
path_id
Guided Path ID.
path_published_version
Published Path version.
path_name
Guided Path Name.
path_description
Guided Path description.
path_uid
GUID used to uniquely identify a Guided Path.
path_tags
Self-Service tags configured for the Guided Path.
path_audience
Guided Path intended audience. -
1. Agent-Facing (string AGENT)
2. Consumer-Facing (string CONSUMER)
3. Both (string ALL)
path_help_id
Self-Service help ID configured for referring to this Guided Path in Self-Service app.
path_time_modified
Date and time the Path was last modified.
category_id
Category ID.
category_name
Category name.
category_enabled
This field contains True if the Category is enabled.
category_display_order
Category image display order.
category_time_created
Date and time of Category creation.
category_time_modified
Date and time of Category modification.
category_uid
GUID used to uniquely identify a Category.
category_ancestors
Ancestors or parent category.



Path_Timeline



This view displays information regarding how a Guided Path was chosen for delivery and statistics about the Path's usage in a Session.
session_id
Id of the session on which the delivery occurred
session_path_id
If a session used multiple workflows, there's one session_workflow_id for each GP selection
category_name
Category chosen to select the Guided Path
path_id
Guided path id
path_name
Guided Path Name
session_path_aborted
Whether the GP delivery was aborted or not
attended_duration
Amount of time spent on the path in the session
session_path_start_time
Time at which workflow was chosen
session_path_end_time
Time at which workflow was closed
total_steps
Total number of steps in the Workflow
completed_percent
Percentage of steps completed during delivery



Session_Agent_Comments



This view displays information regarding Agent comments.
session_id
Session ID. (Primary Key)
agent_id
Agent ID.
agent_email
Agent email.
time_created
Date and time of comment creation.
agent_comment
Agent comment.



Session_Consumer_Device_Data



This view displays information regarding a Consumer's device.
session_id
Session ID. (Primary Key)
start_time
Date and time Session started.
device_id
Device ID. (Foreign Key)
device_type
Type of device. ('computer' or 'mobile' or 'other')
device_name
Device name.
device_os
Device operating system information.
device_time_created
Date and time of device record creation.
device_arch
Device architecture.
device_memory
Device RAM.
device_serial
Device serial.
device_serial2
Device serial 2.
device_vendor
Device manufacturer.
device_model
Device model.
device_ip_address
Device IP address.
device_os_lang
Device operating system language.