# \[BUG-13654\]ackUser and ackNnotes not being stored in alarm journal **URL:** \ **Category:** Ignition Early Access\ **Created:** [April 19, 2019, 4:42am UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246 "2019-04-19T04:42:57Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![sudipta.tripathy](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@sudipta.tripathy](https://forum.inductiveautomation.com/u/sudipta.tripathy)\ **Post date:** [April 19, 2019, 4:42am UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/1 "2019-04-19T04:42:58Z")
Although system.alarm.acknowledge(alarmIds, [notes], username) function has username as one of the parameters, I can’t find where it is stored in the database. I would like to show the user who acked or cleared the alarm. Is there an easy way to find out? Do I need to create a custom alarm attribute to store it? ---
**Author:** ![anjoroge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/anjoroge/32/6698_2.png) [@anjoroge](https://forum.inductiveautomation.com/u/anjoroge)\ **Post date:** [April 22, 2019, 5:35pm UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/2 "2019-04-22T17:35:15Z")
Hi sudipta.tripathy, If you add the system.alarm.acknowledge function with a username parameter in a gateway event script such as the start and shutdown you will be able to see who acknowledged the script based whose username you have used in the wrapper logs. below is a link that should help you. [https://docs.inductiveautomation.com/display/DOC80/system.alarm.acknowledge](https://docs.inductiveautomation.com/display/DOC80/system.alarm.acknowledge) Thanks Anthony ---
**Author:** ![sudipta.tripathy](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@sudipta.tripathy](https://forum.inductiveautomation.com/u/sudipta.tripathy)\ **Post date:** [April 22, 2019, 11:10pm UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/3 "2019-04-22T23:10:18Z")
What I would like to do is to show who acknowledged the alarms by querying the alarm\_event and alarm\_event\_data tables on a perspective page. I was under the impression that the user name gets stored in one of the alarm tables in the database. ---
**Author:** ![anjoroge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/anjoroge/32/6698_2.png) [@anjoroge](https://forum.inductiveautomation.com/u/anjoroge)\ **Post date:** [April 23, 2019, 6:16pm UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/4 "2019-04-23T18:16:39Z")
Hi sudipath.tripathy, This information should be stored in the alarm journal table but currently it is not. We have an open ticket tracking this issue and will try and resolve as soon as possible. [https://docs.inductiveautomation.com/display/DOC80/Alarm+Journal](https://docs.inductiveautomation.com/display/DOC80/Alarm+Journal) Thanks, Anthony ---
**Author:** ![awalker](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awalker/32/6874_2.png) [@awalker](https://forum.inductiveautomation.com/u/awalker)\ **Post date:** [May 8, 2019, 4:28pm UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/5 "2019-05-08T16:28:00Z")
This issue was fixed in the 8.0.2 nightly build that was uploaded today (5/8). ---
**Author:** ![catherine.fowler](https://avatars.discourse-cdn.com/v4/letter/c/34f0e0/32.png) [@catherine.fowler](https://forum.inductiveautomation.com/u/catherine.fowler)\ **Post date:** [November 12, 2020, 8:38pm UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/6 "2020-11-12T20:38:32Z")
I’m running 8.0.16 but still finding this issue. There is no column in the database being stored for username or notes. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/7/27eb2e087dc389a97b4aa8c6c9ef69386878369b.png) Is there something in the configuration I could be missing? ---
**Author:** ![tohhy-pm17](https://avatars.discourse-cdn.com/v4/letter/t/e19adc/32.png) [@tohhy-pm17](https://forum.inductiveautomation.com/u/tohhy-pm17)\ **Post date:** [July 26, 2021, 1:36am UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/7 "2021-07-26T01:36:14Z")
Hi @catherine.fowler , may I know that did you solve the problem you mentioned above because currently I also facing the same problems. ---
**Author:** ![catherine.fowler](https://avatars.discourse-cdn.com/v4/letter/c/34f0e0/32.png) [@catherine.fowler](https://forum.inductiveautomation.com/u/catherine.fowler)\ **Post date:** [July 26, 2021, 12:53pm UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/8 "2021-07-26T12:53:02Z")
Hi @tohhy-pm17, take a closer look at the alarm\_event\_data table. You’ll find that there are entries that store that information in there. For example, if you look for entries where propname is ackUser, you’ll find the strvalue column contains the information about what user acknowledged the alarm. `SELECT * FROM alarm_event_data WHERE propname='ackUser'` ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/5/a56490c8230b58f3c4495073d4988fcaa085b80f.png) The id column is a reference to the alarm\_events table, so you can relate it to that table to determine which alarm it was. Hope this helps! ---
**Author:** ![tohhy-pm17](https://avatars.discourse-cdn.com/v4/letter/t/e19adc/32.png) [@tohhy-pm17](https://forum.inductiveautomation.com/u/tohhy-pm17)\ **Post date:** [July 28, 2021, 12:42am UTC](https://forum.inductiveautomation.com/t/bug-13654-ackuser-and-acknnotes-not-being-stored-in-alarm-journal/24246/9 "2021-07-28T00:42:55Z")
@catherine.fowler Thanks for your help. Appreciate it.