Adding columns to default Ignition Audit log table

Ignition
1

Hi All,

We have a requirement that when a tag value is changed from perspective client, For example a setpoint change of a tag. We need to see the log as XXXtag value changed from XX to XXX with some reason added to it. As ignition default audit log data does not show this kind of log, we thought to add extra columns to the “audit_events” table (This was automatically created when we enable audit log option in project property) and manually push event log by a button press or from input field components etc.,

Will this breaks anything? and ignition audit trail will not function normally?

can anyone please suggest on this?

Thanks
Rajesh

2

Hi Guys,
I have the same question, can we add fields to the Audit table?
Thanks!
JM

3

Should be fine in normal circumstances. I understand some regulated environments require audit tables to be INSERT only--no UPDATE. You should investigate that. If you have that constraint, you should use another table to hold reasons with a foreign key to the audit table. And likely make that table non-UPDATE also.

4

Thanks!