ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Open session

book

Article ID: 186312

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

We did a review of the table of session_log and we see many open sessions that there is a login_time but logout_time is blank. Why this happens and how can I run reports on this session_log table?

Environment

Release : 17.1 and up

Component : SERVICE DESK MANAGER

Resolution

When the session is time out instead of users manually log out, you will see "open" session records in session_log table that logout_time is blank.
So if you want to report on this session_log table, your reporting script would need to construct the logout_time=login_time + timeout locally. For example, if it is a web interface session and you use the default 60 minutes as timeout, then logout_time=login_time+60 minutes.