# Alert\_log Table missing

**URL:** <https://forum.inductiveautomation.com/t/alert-log-table-missing/8291>\
**Category:** Ignition\
**Created:** [April 9, 2014, 10:16pm UTC](https://forum.inductiveautomation.com/t/alert-log-table-missing/8291 "2014-04-09T22:16:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![controlsim](https://avatars.discourse-cdn.com/v4/letter/c/47e85d/32.png) [@controlsim](https://forum.inductiveautomation.com/u/controlsim)\
**Post date:** [April 9, 2014, 10:16pm UTC](https://forum.inductiveautomation.com/t/alert-log-table-missing/8291/1 "2014-04-09T22:16:45Z")

</div>

[size=130]I install Ignition in a new pc and I realized there is not an “alert\_log” table in my db.

[attachment=1]alert2.png[/attachment]

but in my previous installation i have the “alert\_log” table

[attachment=0]alert1.JPG[/attachment]

I need that table for show historical alarms, I try with an alarm journal, it worked but with some issues I explained in this topic [http://www.inductiveautomation.com/forum/viewtopic.php?f=70&t=12109](http://www.inductiveautomation.com/forum/viewtopic.php?f=70&t=12109), so I need this solution or to use the alarm journal.[/size]

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [April 10, 2014, 11:57am UTC](https://forum.inductiveautomation.com/t/alert-log-table-missing/8291/2 "2014-04-10T11:57:28Z")

</div>

The Alert\_Log is no longer used, it uses alarm\_events and alarm\_events\_data now

---

<div class="post-metadata">

**Author:** ![controlsim](https://avatars.discourse-cdn.com/v4/letter/c/47e85d/32.png) [@controlsim](https://forum.inductiveautomation.com/u/controlsim)\
**Post date:** [April 10, 2014, 1:16pm UTC](https://forum.inductiveautomation.com/t/alert-log-table-missing/8291/3 "2014-04-10T13:16:03Z")

</div>

[size=130]If I query the alarm\_events table I get this

[attachment=1]alarm\_events.jpg[/attachment]

and the alarm\_event\_data show this

[attachment=0]alarm\_event\_data.jpg[/attachment]

all the data is separated in this two tables, so why is this better than the old alert\_log table?  
the alert\_log table showed all the data and now I don’t know how to show it in a table component, I tryed with an alarm journal but it gives me error when I try to use “focus on selected alarm”. [/size]

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [April 10, 2014, 7:59pm UTC](https://forum.inductiveautomation.com/t/alert-log-table-missing/8291/4 "2014-04-10T19:59:25Z")

</div>

I’m not sure what your question is?

---

<div class="post-metadata">

**Author:** ![controlsim](https://avatars.discourse-cdn.com/v4/letter/c/47e85d/32.png) [@controlsim](https://forum.inductiveautomation.com/u/controlsim)\
**Post date:** [April 10, 2014, 8:19pm UTC](https://forum.inductiveautomation.com/t/alert-log-table-missing/8291/5 "2014-04-10T20:19:49Z")

</div>

My question is How can I bring the data from “alarm\_events” and “alarm\_event\_data” just like when I bringed the data from the “alert\_log”