We successfully use Usage Tracking to log user queries.
But we want to log user export actions.
Is there any way to do it?
Then I would DEFINITELY go for the log writer. Write your own custom logs and trickle-feed them into a DB table. If you do it, do it properly A to Z and forget the JH part.
Nice little project you got there.
As extra info, this is the kind of logging I talk about: https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-BC51D576-D373-4EEF-8C09-47FD10127F68.htm
As you can see the writer implementations aren't many, not much more than logging in a file or standard output. It isn't like a Java logger which could more easily write in a database directly.
But, if you have an Oracle database, you could try to read the file directly there. If you set it as XML output you have good chances to be able to define the log file as an external table and query it (just don't sure how it will deal with the constant writing to that file). So it's either manual scripting, or database work or use one of the many tools on the market (or opensource) to deal with log files, parse them and write them somewhere else.
I tried and this works...but
1. There is no info about who did the export - only xml and source file with data. We havw to identify who did this
2. CVS-exports aren't logging
https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-BC51D576-D373-4EEF-8C09-47FD10127F68.htm
There is no detail info or examples that can help me(
