Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

SYSADMIN login and IP address

edited Apr 21, 2016 5:05AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

Hi ,

Using the below query I could see SYSADMIN user is logged into instance via form.

But not able to get IP address of the machine who logged in as SYSADMIN user

SELECT apps.fnd_user.user_name,apps.fnd_logins.START_TIME, apps.fnd_logins.END_TIME, apps.fnd_logins.LOGIN_TYPE    

FROM apps.fnd_logins, apps.fnd_user

WHERE apps.fnd_logins.user_id = apps.fnd_user.user_id

AND TO_CHAR(start_time, 'DD/MM/YYYY') = TO_CHAR(SYSDATE, 'DD/MM/YYYY')

AND login_type= 'FORM' 

and apps.fnd_user.USER_NAME = 'SYSADMIN'

ORDER BY start_time DESC;

Tagged:

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