PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to find end user given database session info?

FSCM 9.2, tools 8.59.16; Oracle database 19c

In the PeopleSoft database, username of v$session is always the generic 'SYSADM'. Columns module, action, and client_info of this view have more information but none tells us what the end user is. Note

E-SEC/AS: How to Retrieve Information on Users Currently Logged In/On (Doc ID 614861.1)

is closest to what I want, e.g, running the SQL in the note

SQL> select nvl(b.oprdefndesc,'Blank'), a.CLIENT_INFO
 2 ,a.OSUSER, a.machine, a.PROGRAM
 3 from v$session a, psoprdefn b
 4 where
 5 a.USERNAME is not null
 6 and substr(a.client_info, 1, 7) = substr(b.oprid,1,7)
 7 /

NVL(B.OPRDEFNDESC,'BLANK')    CLIENT_INFO                        OSUSER              MACHINE                                 PROGRAM
------------------------------ ----------------------------------- -------------------- ---------------------------------------- ------------------------------------------------
MDA-System User Profile       PSMAPPS,psoft,appserver01,,PSAESRV, psoft               appserver01                             PSAESRV@appserver01 (TNS V1-V3)
...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center