How can we run reports on session_log table?
search cancel

How can we run reports on session_log table?


Article ID: 186312


Updated On:


CA Service Management - Asset Portfolio Management CA 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?


CA Service Desk Manager - All Versions.


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.