This discussion is archived
0 Replies Latest reply: Aug 27, 2013 1:59 PM by user8081241 RSS

Reporting SYS.FGA_LOG$.CLIENTID in Audit Vault

user8081241 Newbie
Currently Being Moderated

Has anyone found a way to report on the session CLIENTID field collected from the FGA audit log table (SYS.FGA_LOG$)?   We are trying to deploy Audit Vault against our PeopleSoft system, and because of the PIA architecture, all DML actions are logged under one generic database user ID (namely PSFT).  The application session user id (eg JOEBLOW) is being captured in the FGA, but stored elsewhere in the CLIENTID column.

 

When Audit Vault collects the records, it puts CLIENTID into a CLOB column called EXTENSION along with a dozen other fields.   None of the built-in reports can interpret the values in EXTENSION.   The only way I can think of working around this is to build a custom report definition/template, but that seems like extra work that should come with the Audit Vault product.   Also, you can't custom build interactive reports. 

 

Looks like this product is incomplete to me?

 

Lawrence

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points