# Alarm Name, Label and Ack user in Database **URL:** \ **Category:** General Discussion\ **Created:** [June 1, 2023, 10:01am UTC](https://forum.inductiveautomation.com/t/alarm-name-label-and-ack-user-in-database/74427 "2023-06-01T10:01:14Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Faisal\_Shaikh](https://avatars.discourse-cdn.com/v4/letter/f/3ec8ea/32.png) [@Faisal\_Shaikh](https://forum.inductiveautomation.com/u/Faisal_Shaikh)\ **Post date:** [June 1, 2023, 10:01am UTC](https://forum.inductiveautomation.com/t/alarm-name-label-and-ack-user-in-database/74427/1 "2023-06-01T10:01:14Z")
Hi, I am not able to view the columns like Alarm Name, Label and Ack user in the Database, Which configuration I need to enable these columns in the Alarm database. ---
**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:** [June 1, 2023, 12:22pm UTC](https://forum.inductiveautomation.com/t/alarm-name-label-and-ack-user-in-database/74427/2 "2023-06-01T12:22:39Z")
They are in two separate tables. Join them with SQL to get the details.. ---
**Author:** ![jacob.mann](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jacob.mann/32/35821_2.png) [@jacob.mann](https://forum.inductiveautomation.com/u/jacob.mann)\ **Post date:** [August 15, 2023, 3:36am UTC](https://forum.inductiveautomation.com/t/alarm-name-label-and-ack-user-in-database/74427/3 "2023-08-15T03:36:46Z")
following on this thread - are default Alarm properties such as 'Label', and custom properties such as 'Associated Data' stored directly in either two default database tables? Even after enabling the four Event Data storage options in the Journal config page of the Gateway, the two database tables still only have the same data columns available. Is there something else needed to store and access those properties? ---
**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:** [August 15, 2023, 11:47am UTC](https://forum.inductiveautomation.com/t/alarm-name-label-and-ack-user-in-database/74427/4 "2023-08-15T11:47:55Z")
They end up in separate rows of the alarm\_event\_data table, but only if you've selected the "static config" and/or "dynamic config" options in the journal definition. [https://docs.inductiveautomation.com/display/DOC81/Alarm+Journal#AlarmJournal-TableDefinitions](https://docs.inductiveautomation.com/display/DOC81/Alarm+Journal#AlarmJournal-TableDefinitions) ---
**Author:** ![jacob.mann](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jacob.mann/32/35821_2.png) [@jacob.mann](https://forum.inductiveautomation.com/u/jacob.mann)\ **Post date:** [August 16, 2023, 12:13am UTC](https://forum.inductiveautomation.com/t/alarm-name-label-and-ack-user-in-database/74427/5 "2023-08-16T00:13:22Z")
I dont really understand, I have enabled both of these settings in the GW, as well as the associated data options, but I still am not seeing them in my DB. I expected the additional data (label, associated data, etc.) to be stored as additional columns of the row for each new alarm event? It doesnt seem to matter which of the radio boxes I check in the GW config page of the Journal, the DB tables always keep the same fields of alarm data for each event. Am I being a dummy and missing something obvious!? ![Journal config](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/1/212127b6f38f20e8ba7dd4401357c0080fdc607a.png) ![Default Alarm Tables in db](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/969e93df7f2da2db3a9d881a44f99aab2aeb40ec.png) ---
**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:** [August 16, 2023, 12:29am UTC](https://forum.inductiveautomation.com/t/alarm-name-label-and-ack-user-in-database/74427/6 "2023-08-16T00:29:34Z")
> [@jacob.mann](#): > > be stored as additional columns of the row for each new alarm event? No, additional rows in alarm\_event\_data, one per property, with the property in `propname`. You need to join the id from alarm\_events with the id in alarm\_event\_data. ---
**Author:** ![jacob.mann](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jacob.mann/32/35821_2.png) [@jacob.mann](https://forum.inductiveautomation.com/u/jacob.mann)\ **Post date:** [August 16, 2023, 1:33am UTC](https://forum.inductiveautomation.com/t/alarm-name-label-and-ack-user-in-database/74427/7 "2023-08-16T01:33:18Z")
Aaaah right, I see the pattern now. Because I was only glancing at the table data, sorted by oldest at the top, I didnt see the new rows with the property names I was after being entered at the bottom of the table. Thanks for clearing that up