Using the PIAF Explorer AF Audit Trail UI takes exceedingly long to pull 3 years worth of audit data. About 2+ hours per month, and includes service accounts that make up 80-90% of the bulk of the query returns. My immediate thought is to go to directly SQL and query the PI Audit data directly.
However there does not appear to be any single SQL table which hosts a table with the following columns Date, Action, Type, Database, Path, Name and User. I fear the data I seek is across many table with no visible linkages.
Does anyone know the SQL query statement I can use to pull a simple report with the above columns? Moreover, allow me to filter by date and exclude users
Example (Sloppy Query)
SELECT Date, Action, Type, Database, Path, Name, User FROM "PIAF-Audit-Table"
Where User <> "DT/svc-int-drv" and Date > '2021-01-01'
ORDER BY Date
