Solved

how can i get user login history details

  • 24 September 2020
  • 5 replies
  • 1485 views

Userlevel 2
Badge +6

at IFS 10 UPD8

I want get user login history 

 

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?

 

icon

Best answer by 0guz 30 September 2020, 08:09

View original

5 replies

Userlevel 4
Badge +10

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.

Userlevel 2
Badge +6

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.

 

Userlevel 4
Badge +10

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).

 

Best regards.

Userlevel 2
Badge +6

 helllo 0guz  thank you very much 

I haven't found a satisfactory answer yet, but I'll look for a little more

Userlevel 5
Badge +8

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
                                       
                                           
                    )
                  values
                   (                    
                                        rec_.USERNAME,
                                        rec_.session_created,
                                        rec_.Ak_Tarih,
                                        rec_.Ak_Saat
                                        
                    );                 
                END LOOP;
      commit;  
END LB_AKKTIF_USER_HISTORY;
     

Reply