Skip to Content

Export SQL of Audit Event

Apr 13 at 11:28 AM


avatar image
Former Member

Hi guys,

I researching how I can export SQL when audit event occurred.

Ex: When i view a report, a record will insert into table ADS_EVENT with EVENT_TYPE_ID is [1002]. I want to view or export SQL insert of that event.

Thank you very much.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dell Stinnett-Christy Apr 13 at 01:43 PM

So you want to see when that event took place, correct? In that case, you can download a good audit universe and a set of sample reports from here. You'll need to follow the instructions to connect the universe to your audit database in the IDT. If you just need the query to get that information, you can look at the universe to see how the tables are linked so that you can write the query.


10 |10000 characters needed characters left characters exceeded