Skip to main content
Question

How to capture IFS Session's Logoff timestamp

  • September 24, 2020
  • 4 replies
  • 278 views

Srikanth
Superhero (Partner)
Forum|alt.badge.img+18

Hi,

Is there any way to capture the timestamp once Users close their IFS IEE Session?

We are trying to create a Quick Report to calculate total login time for IFS Users.

I can capture the LOGON time using IFS or Oracle views. However, capturing LOGOFF time is proving to be challenging as IFS doesn’t disconnect the backend Oracle session immediately, so there is no LOGOFF event recorded at the point of session disconnection. 

Any help or pointers in this regard is appreciated.

TIA,

Sri

4 replies

paul harland
Superhero (Employee)
Forum|alt.badge.img+24

have you tried history logging on FND_CLIENT_LOGON_TAB


Srikanth
Superhero (Partner)
Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • September 24, 2020

I looked at that table and it only has a LOGON but no LOGOFF timestamp, which is the one I am after.


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • September 24, 2020

You can use the history log both ways.

 

   SELECT logons.username,
logons.time_stamp AS logon_date,
logoffs.time_stamp AS logoff_date
FROM history_log_tab logons
LEFT JOIN history_log_tab logoffs
ON logoffs.keys = logons.keys
AND logoffs.table_name = logons.table_name
AND logoffs.lu_name = logons.lu_name
AND logoffs.history_type = '3'
WHERE logons.table_name = 'FND_CLIENT_LOGON_TAB'
AND logons.lu_name = 'FndClientLogon'
AND logons.history_type = '1'
ORDER BY logons.time_stamp DESC;

 


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • September 25, 2020

I doubt FND_CLIENT_LOGON_TAB can be used to accurately capture logoffs.

Record from the table is deleted even when the user is idle.