Question

Login history report

  • 11 October 2022
  • 1 reply
  • 183 views

Badge +1

Hi! I have a question. Is there any way to retrieve login history report ex. from last month or week? 

I’ve found that there is possibility to get last user activity (from other topic) which I edited a bit

SELECT a.identity,
a.description,
a.active,
ifsapp.fnd_user_api.get_last_activity(a.identity) last_login
FROM ifsapp.fnd_user a
WHERE ifsapp.fnd_user_api.get_last_activity(a.identity) IS NOT NULL

 


1 reply

Userlevel 7
Badge +18

Hi @kamil.nowak 
Have you followed the below community thread?
Quick report showing last login of all Users | IFS Community

Reply