# Adding columns to default Ignition Audit log table

**URL:** <https://forum.inductiveautomation.com/t/adding-columns-to-default-ignition-audit-log-table/53571>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [November 30, 2021, 3:40pm UTC](https://forum.inductiveautomation.com/t/adding-columns-to-default-ignition-audit-log-table/53571 "2021-11-30T15:40:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajesh.dayala](https://avatars.discourse-cdn.com/v4/letter/r/91b2a8/32.png) [@rajesh.dayala](https://forum.inductiveautomation.com/u/rajesh.dayala)\
**Post date:** [November 30, 2021, 3:40pm UTC](https://forum.inductiveautomation.com/t/adding-columns-to-default-ignition-audit-log-table/53571/1 "2021-11-30T15:40:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jmorris](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@jmorris](https://forum.inductiveautomation.com/u/jmorris)\
**Post date:** [October 18, 2023, 8:30pm UTC](https://forum.inductiveautomation.com/t/adding-columns-to-default-ignition-audit-log-table/53571/2 "2023-10-18T20:30:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 18, 2023, 8:34pm UTC](https://forum.inductiveautomation.com/t/adding-columns-to-default-ignition-audit-log-table/53571/3 "2023-10-18T20:34:54Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jmorris](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@jmorris](https://forum.inductiveautomation.com/u/jmorris)\
**Post date:** [October 18, 2023, 10:28pm UTC](https://forum.inductiveautomation.com/t/adding-columns-to-default-ignition-audit-log-table/53571/4 "2023-10-18T22:28:23Z")

</div>

Thanks!