add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, August 26

Script to find the users logged in to application



SELECT ppx.full_name
,fu.user_name
,nvl(ppx.email_address
,fu.email_address) AS email_address,fl.end_time,fl.start_time,(fl.end_time-fl.start_time)
FROM apps.per_people_x ppx, apps.fnd_user fu, apps.fnd_logins fl
WHERE fl.start_time > SYSDATE - 2
AND fu.user_id = fl.user_id
AND ppx.person_id(+) = fu.employee_id
AND fu.user_name NOT IN ('INTERFACE', 'SYSADMIN', 'GUEST')
AND fu.user_name in (<enter the user names seperated by comma ','>)
AND fl.end_time is not null
GROUP BY ppx.full_name
,fu.user_name
,nvl(ppx.email_address
,fu.email_address)
,fl.end_time
,fl.start_time
ORDER BY 2Bookmark

No comments: