I know audit logging has been discussed in one form or another in the forums, but wanted to do a pulse check on if there are any formal plans that anyone knows of or a workable solution for a simple log of user activity for a given entity.
For the immediate timeframe, we’re trying to figure out how to tell who made changes to a Part record in Part Maintenance. We only have a handful of users allowed in there, so we’re just trying to see who is making this edit that is incorrect so we can correct through training.
I get it that there are too many fields to determine WHAT value was changed and record the before and after – not nesc looking for that (although that would be tremendous). Right now, we just want to see a list of activity of people making changes to a part.
You can enable the Change Log by using an In-Transaction Data Directive. It lets you choose which fields trigger a log (for example, you might not want to track fields used by MRP or else you’ll be flooded with entries any time MRP runs). It will show you date, time, username, and old → new field values. It also shows record creation.
Note that when a record is deleted, the change log is also deleted. If you want to track deletions, you will need to either send out an email notification or store it in a UD table.
This seems like an option. Does it make sense if I add a Post-Processing Method Directive that looks at the AssemblyName to see if the user is in PartMaintenance. And if so, record something in the change log?
Look in the BPM designer, I don’t see an object to drop regarding the Change Log – is there somewhere I can learn how to engage the Change Log from the BPM Designer (or any tips you can share)?
Change Log may be your friend then. However, it doesn’t log deletes (in fact delete also deletes the change log)
Alternatively you can try using a UD table and create BPMs to monitor the fields you want tracked for add/change/delete in a Pre process. That’d be per-Table BPMs but doable for a reasonable amount of tables/fields.
