Download data in Audit Portlet

[Gaurav Sharma, geändert vor 8 Jahren.]

I needed to track user logins and signups, so I installed the Audit portlet available for Liferay EE. Now, I'd like to download the data in the Audit portlet in the form of a CSV file but the portlet does not provide this feature. What is the best way to achieve this?

[Andew Jardine, geändert vor 8 Jahren.]

Hi Gaurav.

Have you tried dumping the audit table using a SQL query?

[David H Nebinger, geändert vor 8 Jahren.]

The problem with a dump (well, you'd have to see it as a problem) is that it will contain the bundle keys and not the language bundle values. There's also the fkeys to the user(s), etc.

So that may be enough for you or you might find it to be a bit raw to work from. But there's nothing stopping you from adding an export option. I think you get the source as part of the audit plugin itself so it should be an option to layer in an export with all the replaced values...