ServicePoint Aria chat session log

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

This tech doc documents the mdb table from which Service Desk admin can extract/query for info like when the chat is used, how long the chat session lasts and the user who originates the chat session from Service Point Aria.

Environment

Release : 17.3

Resolution

The mdb table va_chat_sessions has the info

the last field/last_mod_dt is the time the chat ends and time_stamp is when the chat starts. These date fields have Unix time integer values. And the last_mod_by field is the uuid for the user who originates the chat and with this uuid admin can cross/join query from ca_contact table to have the user's name.