Skip to main content
Question

suggestion

  • August 29, 2025
  • 1 reply
  • 72 views

Forum|alt.badge.img+1
  • Do Gooder (Customer)

Is it possible to get the most frequently searched or used pages in ifs application by the company and by each user?

Example: A is a company, B and C are the sites, Management want to know which the screens are most frequently used by users in site B and C, which user uses which screens in IFS application.  

1 reply

Forum|alt.badge.img+8
  • Sidekick (Partner)
  • September 1, 2025

Hi 

Please check the following links. they might be of help to your issue. 

how can i get user login history details | IFS Community

Tracking User Account Login Events | IFS Community

Inquiry Regarding IFS User Activity Tracking | IFS Community

IFS History User Login log | IFS Community

Below query gives you last login and last logout details of any particular user. If you leave the user blank it will give all users details. You need to be app owner or have permissions to see all users details. 

you can create a quick report to run this as needed. 

SELECT t.identity,
 fnd_user_api.get_last_activity(t.identity) last_login
 , max(r.modified_date) last_logout
FROM FNDRR_USER_CLIENT_PROFILE  T, FNDRR_CLIENT_PROFILE_VALUE  r
WHERE t.identity not like 'IFS%'
and ordinal = 0
and fnd_user_api.Get_Active(identity) = 'TRUE'
and r.profile_id (+) = t.profile_id
and r.modified_date is not null
and t.Identity    LIKE UPPER(NVL('&UserID', '%'))
group by t.identity order by max(r.modified_date) desc;