How can we run reports on session_log table?

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

CA Service Desk Manager - All Versions.

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.