I have Prod Instance .on which i want to make query to find out the logon and logoff time of the particular user ,Assume Devteam's(user name) logon logoff time and want to know the responsibility that is widely used by that user.
FROM fnd_user fu,
WHERE fu.user_id = fur.user_id
AND fr.application_id = fur.responsibility_application_id
AND fr.responsibility_id = fur.responsibility_id
AND Trunc (sysdate) BETWEEN Trunc (fr.start_date) AND
Trunc (Nvl ((
fr.end_date - 1
AND Trunc (sysdate) BETWEEN Trunc (fur.start_date) AND Trunc (
fur.end_date - 1 )
AND user_name LIKE 'USHETTY' --- for all user or for particular user
--AND fur.responsibility_application_id = 155 ?- Check particular resp.
ORDER BY user_name
I am able to find the user id and responsibilty assigned and last logon time.but i want to find the logon and logoff both time for particular months.and also want to know which user is active on which responsibily most.
I am in deillema.