webERP Forum
Audit trail enhancements - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Development Discussion & Specification (http://www.weberp.org/forum/forumdisplay.php?fid=10)
+--- Thread: Audit trail enhancements (/showthread.php?tid=2091)



Audit trail enhancements - icedlava - 02-11-2014

Hi there,

Some time ago I noticed that the audit trail only provided entries for insert, update and delete database transactions. A few other features were requested, with one main one being the ability to know when a user logs in.

I was reminded of this change a few days ago and just wondered if it was of any interest here for the main repo. A small change at the moment but I intend to do further audit trail enhancements later.

Cheers,




RE: Audit trail enhancements - Forums - 02-11-2014

(02-11-2014, 12:20 AM)icedlava Wrote: Hi there,

Some time ago I noticed that the audit trail only provided entries for insert, update and delete database transactions. A few other features were requested, with one main one being the ability to know when a user logs in.

I was reminded of this change a few days ago and just wondered if it was of any interest here for the main repo. A small change at the moment but I intend to do further audit trail enhancements later.

Cheers,

This could definitely use some work. As I remember I wrote this about 7 years ago in a couple of hours and apart from some changes by Ricard it hasn't been updated since.

Thanks
Tim


RE: Audit trail enhancements - phil - 02-11-2014

The last login in date time is recorded against the www_users table ... but no log remains of user logins

EDIT:
Of course the update to www_users will be in the audit trail log too


RE: Audit trail enhancements - Forums - 02-11-2014

Thanks for the compliments Phil, but I still feel it can be improved upon. The sql parsing is not bad, but is still only about 95%. There are dedicated open source sql parsers such as https://code.google.com/p/php-sql-parser/ which could improve the accuracy and the speed of the parsing.

Tim


RE: Audit trail enhancements - PakRicard - 02-12-2014

(02-11-2014, 12:20 AM)icedlava Wrote: Hi there,

Some time ago I noticed that the audit trail only provided entries for insert, update and delete database transactions. A few other features were requested, with one main one being the ability to know when a user logs in.

I was reminded of this change a few days ago and just wondered if it was of any interest here for the main repo. A small change at the moment but I intend to do further audit trail enhancements later.

Cheers,

Hi Jo:

I personally use the audit quite often, and ANY improvement on the functionality will be really welcomed. Count on me for tests :-)



RE: Audit trail enhancements - kelo - 05-05-2014

hi.. i am added ip loggin script ..
please see my thread http://www.weberp.org/forum/showthread.php?tid=2215
and please leave your comment or oppinion.