Is there a way to see who is logged into the Service Point interface?

Products

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

Issue/Introduction

Is there a way to see who is logged into the Service Point interface?

Environment

Release : 17.3

Component : XFLOW INTERFACE FOR SDM

Resolution

If you have session_log enabled, then you can find the information in the session_log table, where the session_type = 12.

Session type = 12 refers to xFlow/Service Point session.


A report can be created to see what users logged into xFlow/SP (session_type=12) on a specific day or timeframe. Here some documents that will help to build some query's to get the data from session_log table:

Where to find data (date, time, user, ..) related to Service Desk login/logout?

The LOGOUT_TIME column is null on the session_log table.

How to obtain in a standard date/time format the values of 'open_date' and 'close_date' fields stored in the call_req table.

What is the SQL Query to view dates from Service Desk Manager tables in Standard Date & Time format?