Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex 20.1 and APEX_ACTIVITY_LOG question

Hi there,
My customer wants to monitor the access to a particular application, especially the IP Adress and User Agent.

SELECT time_stamp, userid, userid_lc, ip_address,user_agent
    FROM APEX_ACTIVITY_LOG
 WHERE flow_id = :APP_ID
   AND  time_stamp > (SYSDATE-1)
   order by time_stamp desc

So I made a simple IR with the select above, but I only get the userid , no Ip or User Agent.
The application property "Logging " is set to 'Yes"
What did I missed ?
Regards
JeanYves Bernier

This post has been answered by jariola on Nov 11 2020
Jump to Answer
Comments
Post Details
Added on Nov 9 2020
5 comments
671 views