Auditing Queries

Query to get the all list of events registered for auditing

select r.registered_id, r.event,r.user_name
from dmi_registry r
where r.is_audittrail = 1

Query to get list of events corresponding to the object types registered for auditing
select t.name,r.event,r.user_name,t.name
from dmi_registry r, dm_type t
where r.is_audittrail = 1
and t.r_object_id = r.registered_id

Query to get list of events corresponding to the user types registered for auditing
select t.user_name,r.event,r.user_name
from dmi_registry r, dm_user t
where r.is_audittrail = 1
and t.r_object_id = r.registered_id