# Alarm log table **URL:** \ **Category:** Ignition\ **Created:** [January 22, 2013, 9:57pm UTC](https://forum.inductiveautomation.com/t/alarm-log-table/5722 "2013-01-22T21:57:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![flux](https://avatars.discourse-cdn.com/v4/letter/f/ce7236/32.png) [@flux](https://forum.inductiveautomation.com/u/flux)\ **Post date:** [January 22, 2013, 9:57pm UTC](https://forum.inductiveautomation.com/t/alarm-log-table/5722/1 "2013-01-22T21:57:21Z")
Is there a way to customize the auto generated alert\_log table for alerting. I want to add another column in table to describe the alarm so on my report it is much readable. The alarm message/description is coming from a SQLTag. Is this possible? Can I intercept the alert logging event before it stores the records into the database? ---
**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\ **Post date:** [January 22, 2013, 10:45pm UTC](https://forum.inductiveautomation.com/t/alarm-log-table/5722/2 "2013-01-22T22:45:32Z")
You can't get it to create it for you but you should be able to add columns for personal use after it has been created. ---
**Author:** ![flux](https://avatars.discourse-cdn.com/v4/letter/f/ce7236/32.png) [@flux](https://forum.inductiveautomation.com/u/flux)\ **Post date:** [January 22, 2013, 10:58pm UTC](https://forum.inductiveautomation.com/t/alarm-log-table/5722/3 "2013-01-22T22:58:24Z")
So I guess I’ll have to manually update the row after a record has been inserted. Is there a way to intercept the alert logging event? Dave do you think I can achieve this using Transaction Group? ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [January 23, 2013, 12:10am UTC](https://forum.inductiveautomation.com/t/alarm-log-table/5722/4 "2013-01-23T00:10:10Z")
You cannot intercept the alert logging event, it is behind the scenes. You can handle this with transaction groups but you will have to implement adding and updating alerts in the database which is a lot of work. ---
**Author:** ![flux](https://avatars.discourse-cdn.com/v4/letter/f/ce7236/32.png) [@flux](https://forum.inductiveautomation.com/u/flux)\ **Post date:** [January 23, 2013, 2:56am UTC](https://forum.inductiveautomation.com/t/alarm-log-table/5722/5 "2013-01-23T02:56:33Z")
Travis, Is it possible to create a transaction group that inserts and updates multiple OPC tags into one column? I have around 250 alarm messages on the PLC that I would like to use on my report. Since what I would like to do it not easily possible. I’m planning on storing the alarm messages into a separate table and just SQL join it with the alert\_log table when generating a report. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [January 23, 2013, 4:08pm UTC](https://forum.inductiveautomation.com/t/alarm-log-table/5722/6 "2013-01-23T16:08:28Z")
No the standard and history groups only work with one row of data. The block data group works with multiple rows but it will be tricky to only insert rows where the alert is active. You might just be better of creating gateway tag change event scripts that inserts a row into the database when it goes active and updates the row when it clears using scripting. ---
**Author:** ![flux](https://avatars.discourse-cdn.com/v4/letter/f/ce7236/32.png) [@flux](https://forum.inductiveautomation.com/u/flux)\ **Post date:** [January 23, 2013, 5:14pm UTC](https://forum.inductiveautomation.com/t/alarm-log-table/5722/7 "2013-01-23T17:14:45Z")
Thanks Travis I will try that out.