ServicePoint Aria chat session log

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

This document indicates the MDB table from which one can extract/query for information about when the Aria chat is used, how long the chat session lasts and the user who originated the chat session from Service Point Aria.

Environment

Release : 17.3

Resolution

The MDB table va_chat_sessions has the information regarding Aria chat sessions

The 'last_mod_dt' field contains the time the chat ends and 'time_stamp' field indicates when the chat started.  These date fields have Unix time integer values.

The 'last_mod_by' field is the UUID for the user who originated the chat and with this UUID, you can cross/join query from the ca_contact MDB table to obtain the user's name.