database changes report or audit log?
Posted: Thu Apr 09, 2009 11:40 am
The system administrator at our church would like to know if there is a way in PC+ to see who made updates to any database and what they updated since the last job was run. The problem is knowing who changed profiles or payables, in case something was typed in error.
The request is for a report that prints which user did it and when, the original data in the field, the new info in the field, and even the last time the field was changed since initial setup. Does this exist somewhere in a utility or in the membership module? It would be some sort of audit log, I would guess.
What we are trying to do is monitor the volunteers that come in to help us with attendance, or the occasional helper for contribution data-entry, as well as make sure we are doing our own tasks correctly.
An example would be that we have 5 smith families in our church. Right now, we do not know of a way to double-check ourselves to see if we have indeed changed the correct family (birthdays or phone number, etc.). If this update/audit-log could be run, we could have a history of these changes, should something be found later to be in error.
Any ideas or suggestions out there? Does anyone do this with a custom report or something? Thanks for listening!
The request is for a report that prints which user did it and when, the original data in the field, the new info in the field, and even the last time the field was changed since initial setup. Does this exist somewhere in a utility or in the membership module? It would be some sort of audit log, I would guess.
What we are trying to do is monitor the volunteers that come in to help us with attendance, or the occasional helper for contribution data-entry, as well as make sure we are doing our own tasks correctly.
An example would be that we have 5 smith families in our church. Right now, we do not know of a way to double-check ourselves to see if we have indeed changed the correct family (birthdays or phone number, etc.). If this update/audit-log could be run, we could have a history of these changes, should something be found later to be in error.
Any ideas or suggestions out there? Does anyone do this with a custom report or something? Thanks for listening!