When did the user log in and when did they log out?
the info of under history
1,login user name
2,The user login time
3,The user logout time
4,Best if possible to see what the user did in login time
thank you!
setup it in under table?
Page 1 / 1
Hello @DalShiloZ you can select to fnd_session_runtime i think, than u can follow the view details. If you want to arrive the results on IFS screen u can try this is it enough for your request?
Best regards.
thank you 0guz , fnd_session_runtime can find login time but can’t find logout time , do you know other plan can find user logout time ?
Best regards.
Hello @DalShiloZ
Can you try to follow this way;
Right click and edit to fnd_session_runtime view at pl/SQL
You will arrive the table, than select to table for your request (i mean logout time).
I haven't found a satisfactory answer yet, but I'll look for a little more
Hello @DalShiloZ@0guz
I created a Job that writes the users registered in the system to the table every 19 minutes. In this direction, I provide transfers 3 times per hour. This process gives me both how often users use IFS and which user has been open for how many hours.
procedure LB_AKKTIF_USER_HISTORY IS begin commit;
FOR rec_ IN ( SELECT s.USERNAME ,s.session_created, sysdate Ak_Tarih, to_char(sysdate,'hh24:mi:ss')Ak_Saat FROM FND_CLIENT_LOGON2 s ) LOOP insert into IFS_AKTIF_USER ( USERNAME, session_created, Ak_Tarih, Ak_Saat