Skip to main content
Solved

how can i get user login history details

  • September 24, 2020
  • 5 replies
  • 2006 views

Forum|alt.badge.img+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?

 

Best answer by 0guz

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.

View original
Did this topic help you find an answer to your question?

5 replies

0guz
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 64 replies
  • September 24, 2020

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.


Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • 7 replies
  • September 30, 2020

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.

 


0guz
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 64 replies
  • Answer
  • September 30, 2020

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.


Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • 7 replies
  • October 5, 2020

 helllo 0guz  thank you very much 

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


ADNAN
Sidekick
Forum|alt.badge.img+8
  • Sidekick
  • 53 replies
  • October 5, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings