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.
Article ID: 186312
CA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
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?
Release : 17.1 and up
Component : SERVICE DESK MANAGER
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.