# Best way to assemble every tags alert status into a table? **URL:** \ **Category:** Ignition\ **Created:** [March 2, 2011, 10:19pm UTC](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712 "2011-03-02T22:19:02Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [March 2, 2011, 10:19pm UTC](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712/1 "2011-03-02T22:19:02Z")
I am planning on using a odbc to opc client to make all of my tag alarm status available to win911 for callout functionality. I am having trouble figuring out the best way to put every tag in the tag database active alert status into a database table that would be updated say every minute. Also, the alert status has to be overwritten in the same row that it was originally placed, or it would throw everything off. so lets say I have 50 total tags. I would want every one of those to be placed in a specific order in a table, with the name of the tag in one column, then the value of the alert active state in another column. The odbc to opc software would look at the value column and would call row 1 in the value column tag 1. row 2 tag 2, and so on. anyone have any ideas on what to do? I can have up to about 15000 of these when Im done so it is important that it works efficiently. ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [March 3, 2011, 12:48am UTC](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712/2 "2011-03-03T00:48:00Z")
You can use a table similar to the one created by an external Alert Storage Profile and add or remove a few columns to get what you want. SQL databases are very good at storing a large number of rows in a single table, so 1500 rows are not enough to worry about performance issues. ---
**Author:** ![DaneOverfield](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@DaneOverfield](https://forum.inductiveautomation.com/u/DaneOverfield)\ **Post date:** [February 25, 2012, 2:05am UTC](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712/3 "2012-02-25T02:05:57Z")
TopView SQL from Exele [exele.com/Products/TopView/topview\_about.htm](http://www.exele.com/Products/TopView/topview_about.htm) We have added some details of integrating TopView SQL to Ignition. [exele.com/Products/TopView/s … /index.htm](http://www.exele.com/Products/TopView/solutions/ignition/index.htm) ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [February 25, 2012, 5:40am UTC](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712/4 "2012-02-25T05:40:48Z")
C’mon, Dane, really? The other five threads weren’t enough? Resurrecting threads a year-old is just bad form, and doesn’t really add anything since it’s just copy/paste. Now, if you were provide some real-world examples and more useful information, I probably wouldn’t be as annoyed as I seem to be at this borderline spamming. Just sayin’! 😠 ---
**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Post date:** [February 25, 2012, 4:24pm UTC](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712/5 "2012-02-25T16:24:35Z")
And the link is broken… ---
**Author:** ![DaneOverfield](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@DaneOverfield](https://forum.inductiveautomation.com/u/DaneOverfield)\ **Post date:** [April 11, 2013, 12:12am UTC](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712/6 "2013-04-11T00:12:24Z")
> [@JordanCClark](#): > > C'mon, Dane, really? The other five threads weren't enough? Resurrecting threads a year-old is just bad form, and doesn't really add anything since it's just copy/paste. Now, if you were provide some real-world examples and more useful information, I probably wouldn't be as annoyed as I seem to be at this borderline spamming. Just sayin'! 😠 I fixed the link and it does provide the details of a real world example which was the purpose of my post.