Oracle Applications Script List Apps Login Times

Updated : 30-July-2002
Version : 1.0

Description

Displays login details of Oracle Apps users

Parameters

None.

SQL Source

set verify off
set pages 200

spool apps_login.lst


column sid form 999
column spid for a5 heading "Unix|Serv|Pid" trunc 
column logon_time format a13

column user_name form a12 heading "Apps User"
column description form a35 heading "Description" wrap

select s.SID, p.SPID, to_char(logon_time,'dd-mon hh24:mi')  logon_time
      , f.user_name, u.description
from v$session s, v$process p, FND_SIGNON_AUDIT_VIEW f, FND_USER u
where p.addr = s.paddr
and s.username is not null 
and f.process_spid = p.spid
and f.user_id = u.user_id
/                      

spool off

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal