# Insert manually alerts in alert\_log table

**URL:** <https://forum.inductiveautomation.com/t/insert-manually-alerts-in-alert-log-table/2273>\
**Category:** Archived Topics\
**Created:** [October 19, 2010, 7:50am UTC](https://forum.inductiveautomation.com/t/insert-manually-alerts-in-alert-log-table/2273 "2010-10-19T07:50:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Oriol](https://avatars.discourse-cdn.com/v4/letter/o/7cd45c/32.png) [@Oriol](https://forum.inductiveautomation.com/u/Oriol)\
**Post date:** [October 19, 2010, 7:50am UTC](https://forum.inductiveautomation.com/t/insert-manually-alerts-in-alert-log-table/2273/1 "2010-10-19T07:50:57Z")

</div>

Is there any way to insert manually alerts in alert\_log table?

We are working with a device that has its own alerts buffer. We are retrieving this alerts buffer and would like to insert them directly in the Ignition default alerts management system.

These external alerts must be read and inserted directly on alert\_log table and cannot be related to any tag-based Ignition alert.

What we haved tried is inserting directly the information on the alert\_log table, but the alert summary component is displaying only Ignition alerts and not the ones imported from the external device. Do think this is because we should import these external alerts somewhere else besides alert\_log table?

---

<div class="post-metadata">

**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:** [October 19, 2010, 3:13pm UTC](https://forum.inductiveautomation.com/t/insert-manually-alerts-in-alert-log-table/2273/2 "2010-10-19T15:13:46Z")

</div>

The alert summary table only shows the current status of all the alerts. In order for a record to show up that alert must be registered in the system from a SQLTag. You can insert information into the alert\_log table manually by doing an insert query in scripting. Once you do that you can make your own alert status table by querying the alert\_log table and only showing the active alarms. Hope this helps.

---

<div class="post-metadata">

**Author:** ![Oriol](https://avatars.discourse-cdn.com/v4/letter/o/7cd45c/32.png) [@Oriol](https://forum.inductiveautomation.com/u/Oriol)\
**Post date:** [October 22, 2010, 7:26am UTC](https://forum.inductiveautomation.com/t/insert-manually-alerts-in-alert-log-table/2273/3 "2010-10-22T07:26:43Z")

</div>

Thanks a lot. Finally I’ve selected data by doing different querys: one for system’s alerts and one for alerts manually inserted.
