This content has been marked as final. Show 2 replies
change start_time and use end_time for your time gap.
SELECT DISTINCT ppf.full_nameRegards
, NVL(ppf.email_address,fu.email_address) email_address
FROM per_people_f ppf
, fnd_user fu
, fnd_logins fl
WHERE fl.start_time > SYSDATE - 2
AND fu.user_id = fl.user_id
AND ppf.person_id(+) = fu.employee_id
AND fu.user_name NOT IN ('SYSADMIN', 'GUEST')
Hi Prashant Pathak
Thanks for your prompt reply.
Could you please kindly modify the query for me to get the users currently (at the time of running the script) log -into the system