SYSADMIN login and IP address
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;