I want to fetch the oracle user login detail for the month February. I tried the below query.
select distinct os_username,username,userhost,terminal,timestamp,action_name,logoff_time from dba_audit_session where timestamp between '01-FEB-2017' and '28-FEB-2017' order by timestamp;
but I need the IP address as well. Can anyone help me! how to fetch the user IP address along each user session?
I am stuck here.
I have check
dba_audit_trail table as well but didn't help.
I need the below columns:
username,os_user,logon_date,logoff_date,IPADDR, terminal, sessionid,hostname.