# How use SQLTags Alarm Edit extra?

**URL:** <https://forum.inductiveautomation.com/t/how-use-sqltags-alarm-edit-extra/3063>\
**Category:** Ignition\
**Created:** [July 6, 2011, 10:49am UTC](https://forum.inductiveautomation.com/t/how-use-sqltags-alarm-edit-extra/3063 "2011-07-06T10:49:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Antonio](https://avatars.discourse-cdn.com/v4/letter/a/6de8d8/32.png) [@Antonio](https://forum.inductiveautomation.com/u/Antonio)\
**Post date:** [July 6, 2011, 10:49am UTC](https://forum.inductiveautomation.com/t/how-use-sqltags-alarm-edit-extra/3063/1 "2011-07-06T10:49:36Z")

</div>

Hello  
In pretty new in the world of the Ignition, but each day that i’m using and learning this SCADA software i like more and more.  
But in the part of alarm config I got the problem that i need a window that configurate the alarm ranges or/and disable it.  
I imported the extra SQLTags Alarm Edit window in my proyect and of course it not working. the problem cames with the queries.

The tables sqlt\_meta, sqlt\_as and sqltcore have the information of the tags and playing with the queries you can change the alarm ranges but there are not information about how i can connect that with my tags or how should be each colum of the each 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:** [July 6, 2011, 2:51pm UTC](https://forum.inductiveautomation.com/t/how-use-sqltags-alarm-edit-extra/3063/2 "2011-07-06T14:51:00Z")

</div>

Take a look at the attached zip file. It contains information about the SQLTag tables in the database. For example, there is a sqlt\_core table that contains a record for each tag. Each tag has an id. The sqlt\_as contains the alarm states for each tag based on the tagid. That is how they are linked up. If you alter the alarm state you also need to update the config timestamp on the sqlt\_core table:`UPDATE sqlt_core SET configchange = CURRENT_TIMESTAMP WHERE id = 1`Let us know if you have more questions.  
[sqltags.zip](https://us1.discourse-cdn.com/inductiveautomation/original/1X/442496d04e0e87f068d88ccd8d98bc7a2624d3f5.zip) (79.5 KB)
