We are wondering about the LF Audit Trail. We know event types 32,33 are export and print.
We notice that the Audit_Event table has these event types.
We are basically trying to find all docs that have had an export or print event.
When we try to join to the audit_entry table. We do NOT find any associated entries hooking up Audit Event to Audit Entry tables.
But for other event types we do.
We also notice that we get successful joins to the Audit_page_range when joining to the Audit_Event table via the event id.
What we can’t figure out is how to know which document was exported or printed from the Audit Trail database.
We are trying to write a SQL Query to provide this information