Oracle SQL - get a list of most recent user logins

/ Published in: SQL
Save to your folder(s)

Query to find the most recent logins for a particular user ( find 1 years worth )

Copy this code and paste it in your HTML
  1. SELECT fl.login_id, fl.start_time, fl.end_time,, fl.spid, fl.terminal_id, fl.login_name, fl.session_number, fl.submitted_login_id, fl.serial#, fl.process_spid, fl.login_type,
  2. fuv.user_name, fuv.description
  3. FROM FND_LOGINS fl, apps_fnd.fnd_user_v fuv
  4. WHERE
  5. fl.user_id = fuv.user_id
  6. AND fuv.user_name = :P_USER_NAME
  7. AND fl.start_time > (sysdate - 365)
  8. ORDER BY fl.start_time DESC

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.