topic Re: Produce logs in CSV format in Alfresco Archive

Produce logs in CSV format

davisw — Wed, 11 Jun 2014 06:14:13 GMT

Hi,How can I make Logs in CSV format? My corporation would like to get different kinds of logs for security reason.Best regards

Re: Produce logs in CSV format

abarisone — Wed, 11 Jun 2014 10:10:07 GMT

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

Re: Produce logs in CSV format

davisw — Thu, 12 Jun 2014 02:25:18 GMT

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

Re: Produce logs in CSV format

abarisone — Thu, 12 Jun 2014 06:44:28 GMT

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

Re: Produce logs in CSV format

davisw — Mon, 16 Jun 2014 01:14:32 GMT

Hi abarisone,

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

Best regards,
Davis