Standard Audit Trail and Audit Log

Question

Please I need a sample or Source Code for a Standard Audit Trail and Audit Log. I want to know when each of the User performs CRUD action in each of the module. What action was performed (CRUD) When the action was performed Who performed the action IP Address of the System Tack all the events and so on. It must be detail enough and should be on each module.

mike idowu · Answer

Akshay Phadke I want both code sample and database architecture

Akshay Phadke · Answer

@Mike what exactly you want code or Dtabase architecture .

mike idowu · Answer

Akshay Phadke Please can you give a brief code to expanciate

Akshay Phadke · Answer

Basically you want all the details to be captured in your tables .. Thats what i am guessing from you question .. What action was performed (CRUD) ---- Try to keep IDS for all buttons like (AddEditDeletePrint- IDS:12 and so on and save those IDS in table .. So you have a track for that partuclar record wjat exactly user has done. When the action was performed ( Create a field called as Created date and Update Date which will help you when it was created and when it was modified) Who performed the action(create a field called as : Created By and Updated By : Who created it and who updated it ) IP Address of the System ( with the help of scoket servers you can easily trace IP of that system) Tack all the events(Keep all the necessary information in table like on insert submit that data in your main table and on update that data in main table but also insert that updated data in history table and so on.

Mangesh Gaherwar · Answer

you should use Triggers for that purpose apply trigger on each of these column but be catiuos of the performance as one wrong trigger and your application will give u bad performance other way will be to use the seprate db where we can add these entities independently whenever any operation happens make sure whenever this is handeled from code it is made async so it wont affect performance