2. PHPRunner General questions
  3. Audit Log
This topic is locked

Audit Log

 		5/28/2017 5:19:06 PM
PHPRunner General questions
A
 Andrew S author

Is it possible to automatically email the audit.log to myself daily by setting up an event ? i.e. when user logs on first thing in the morning, send me the previous day audit.log.
I appreciate I can download via FTP manually but this can be forgotten or not convenient whilst on holiday etc..
Maybe someone else has wanted this facility and coded something
Any help or advice would be gratefully received. I am using latest phprunner 9.7 with mysql
Thanks

Andrew
jadachDevClub member 5/28/2017

Why not just store the audit in a database table?
H
 		headingwest 5/28/2017

I store the audit data in the database. Then I use a CRON job on my server to run a PHP file that sends emails.
The PHP basically reads any tables I'm interested in then sends a summary to me.
A
 		Andrew S author 5/29/2017

Thanks for responses. I did test storing in database but found the audit log easier for my client to read. I will take another look at using database but with some modifications as currently using the default i.e. phprunner creates the audit table, I found it very unfriendly for search purposes for my application which now holds thousands of records. My aim is to be able to search on jobID and display ALL actions and by whom for an individual job from creation through to the job getting paid and closed. Suspect report will be way forward to achieve this.