AnsweredAssumed Answered

Audit the access

Question asked by ya0045785 on May 19, 2016
Latest reply on May 23, 2016 by ya0045785

Good Morning Everybody,


someone on the blackboard system has been updated the building block without restarting the services.

I've this query to check this activity.

  • we run it after modified the dates and it didn't return any record. Is there any other table or file we can look at?
  • If there's a tool or batch file to get those audit data, this will be great help

My Query:

" select u.user_id,u.firstname,u.lastname,aa.user_pk1,aa.course_pk1,,aa.internal_handle,to_char(aa.timestamp, 'dd/mm/yyyy hh24:mi:ss')

from activity_accumulator aa,users u

where aa.TIMESTAMP between to_date('10-FEB-2016 00:00:00', 'DD-MM-YYYY HH24:MI SS') and to_date('17-FEB-2016 23:59:00', 'DD-MM-YYYY HH24:MI SS')