Produce logs in CSV format

[davisw]

Hi,

How can I make Logs in CSV format?

My corporation would like to get different kinds of logs for security reason.


Best regards

[abarisone]

Hi,
in general you should not confuse the logging procedure with the analyze logging procedure.
Alfresco uses log4j for logging, so you should exploit its appenders to produce a sensible log and then analyze it with some kind of tool.
Here some considerations on this topic:
http://stackoverflow.com/questions/11822581/server-logging-appending-to-an-excel-sheet
http://www.coderanch.com/t/594032/java/java/Writing-CSV-file-LOG-good
and take a look to this project: http://opencsv.sourceforge.net/

Regards,
Andrea

[davisw]

Hi Andrea,

Thank you for your information. The information is deep and detailed, but I can't caught how to utilize them to produce output.

Before I Mark the comment as useful, if you don't mind can you please advise me the steps of one simple case to log who have accessed Alfresco DSM within 1 week.

Best regards,
DavisW

[abarisone]

Hi davisw,
if your target is to log who have logged on Alfresco within the last week, you should enable auditing http://docs.alfresco.com/4.2/concepts/audit-intro.html and then perform queries on the produced tables.
Since you then have all data in DB tables you can extract it in the format you like.

Regards,
Andrea

[davisw]

Hi abarisone,

Your information is useful and going to check the PostgreSQL DB.


Best regards,
Davis