# How to add user user define column on Audit and Alarm **URL:** \ **Category:** Ignition\ **Created:** [October 31, 2013, 5:22am UTC](https://forum.inductiveautomation.com/t/how-to-add-user-user-define-column-on-audit-and-alarm/7502 "2013-10-31T05:22:44Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![sumit](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@sumit](https://forum.inductiveautomation.com/u/sumit)\ **Post date:** [October 31, 2013, 5:22am UTC](https://forum.inductiveautomation.com/t/how-to-add-user-user-define-column-on-audit-and-alarm/7502/1 "2013-10-31T05:22:44Z")
1. How to add user user define column on Audit 2. how to add user define column on Alarm ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [December 26, 2013, 6:49pm UTC](https://forum.inductiveautomation.com/t/how-to-add-user-user-define-column-on-audit-and-alarm/7502/2 "2013-12-26T18:49:43Z")
The audit log and alarm tables are stored in the database. This means that you can add whatever columns you want to them. Once you’ve added them, just write your SQL query to pull in the columns you want. If you are talking about modifying the Alarm Status or Alarm Journal components to show those columns you’ve added, then you can’t. You will have to use the Table component and write your own query. ---
**Author:** ![focusengsk](https://avatars.discourse-cdn.com/v4/letter/f/46a35a/32.png) [@focusengsk](https://forum.inductiveautomation.com/u/focusengsk)\ **Post date:** [January 29, 2018, 2:55pm UTC](https://forum.inductiveautomation.com/t/how-to-add-user-user-define-column-on-audit-and-alarm/7502/3 "2018-01-29T14:55:59Z")
Did you get this working? I am looking at same issue now, I can run a query to add in a user comment, but it means there are two entries on the Audit Events Table, my scripted event and the event generated automatically. What I really want is to append a comment onto the action being performed that will automatically be created. ---
**Author:** ![mjohnson](https://avatars.discourse-cdn.com/v4/letter/m/a9a28c/32.png) [@mjohnson](https://forum.inductiveautomation.com/u/mjohnson)\ **Post date:** [July 24, 2020, 5:16pm UTC](https://forum.inductiveautomation.com/t/how-to-add-user-user-define-column-on-audit-and-alarm/7502/4 "2020-07-24T17:16:52Z")
Is this still the case?