Hi ​@dhanikw did you ever find a solution to this?

I too am having to audit users and this information would be a great help.

Same here. Hey IFS, what are you going to do about this? I see so many posts asking for this information. How difficult can it be to create a table for this and make it available?

Hi ​@FNSFNSMVO 

Actually we discoverd this whilst investigating the backend data sets

select a.identity as user_id,to_char(max(b.modified_date),'YYYY-MM-DD HH24:MI:SS') 
as last_accessed_time 
from ifsapp.FNDRR_USER_CLIENT_PROFILE a,
ifsapp.FNDRR_CLIENT_PROFILE_VALUE b
where a.profile_id = b.profile_id
group by a.identity

IT does the job quite well :) 

Thanks for the quick answer ​@Ian_Coggins! I got the below from my colleague:

We’ve been down a similar track before.

I wrote a query to extract the last modified date from the user profile. It did actually come quite close to providing what we wanted but it relied on the users making at least one screen based change.

For example, adding a bookmark, making a search, changing columns. So if they just did a simple task without making any changes that needed to be saved in their profile, then the date wasn’t updated.

Hence we are still missing users who do not make any such change or do not even login, which is the main purpose for our query. We want to identify who of our >4000 users is NOT login in (anymore) and free up their license. 

A requirement many companies seem to struggle with if I browse through this community.

select a.identity as user_id,to_char(max(b.modified_date),'YYYY-MM-DD HH24:MI:SS') 
as last_accessed_time 
from ifsapp.FNDRR_USER_CLIENT_PROFILE a,
ifsapp.FNDRR_CLIENT_PROFILE_VALUE b
where a.profile_id = b.profile_id
group by a.identity

, thanks ​@Ian_Coggins . I have been looking for this for quite a while now.

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;

Thanks again, very much, but I read in the replies that these queries do not seem to work or do not cover all users in case of users login in through SSO, like in our case. Who can confirm these queries also work when SSO is used?

Did you try the query and checked the users who use SSO?  I am also interested to know if this works. so please try that query and let me know Thanks

We tried and it does not work unfortunately. We do not think the query results can reliably be used to de-activate users. We see users in the result that should not be de-activated and others that should be de-activated are missing. We really hope that IFS can just provide a screen or a report with users last login for all users, active or not active, like pretty much any ERP or other serious application in the market.