Export SQL of Audit Event

[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.

[DellSC]

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.

-Dell