# Find Tag numbers for HACH WIMS integration

**URL:** <https://forum.inductiveautomation.com/t/find-tag-numbers-for-hach-wims-integration/111794>\
**Category:** Ignition\
**Created:** [October 29, 2025, 5:22pm UTC](https://forum.inductiveautomation.com/t/find-tag-numbers-for-hach-wims-integration/111794 "2025-10-29T17:22:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bruno\_Burgin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bruno_burgin/32/80141_2.png) [@Bruno\_Burgin](https://forum.inductiveautomation.com/u/Bruno_Burgin)\
**Post date:** [October 29, 2025, 5:22pm UTC](https://forum.inductiveautomation.com/t/find-tag-numbers-for-hach-wims-integration/111794/1 "2025-10-29T17:22:08Z")

</div>

I am trying to add a few more tags to Hach WIMS, they use a tag ID # to grab the tag from the SQL database. How do I cross reference that ID to an actual tag name?

 ![WIMS Tag](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/5/758a9c08b398d9b0eb701864dd5988a7fa9928d6.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 29, 2025, 5:32pm UTC](https://forum.inductiveautomation.com/t/find-tag-numbers-for-hach-wims-integration/111794/2 "2025-10-29T17:32:08Z")

</div>

Reversing the id used in the `sqlt_data` tables involves reversing the lookup process completely, going from `sqlth_te` to `sqlth_scinfo` and `sqlth_drv`:

> **[Ignition Database Table Reference | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/reference-pages/ignition-database-table-reference#tag-history)**
>
> Ignition has a lot of systems built-in that will query the database automatically without requiring you to build a query. These systems automatically create the necessary tables in the database, insert the relevant data, and even query it back out...

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [October 29, 2025, 5:32pm UTC](https://forum.inductiveautomation.com/t/find-tag-numbers-for-hach-wims-integration/111794/3 "2025-10-29T17:32:51Z")

</div>

You'd need to look at the `sqlth_te` table and reference the `id` column. That table has a `tagPath` column that gives you the full path to the tag.

---

<div class="post-metadata">

**Author:** ![Bruno\_Burgin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bruno_burgin/32/80141_2.png) [@Bruno\_Burgin](https://forum.inductiveautomation.com/u/Bruno_Burgin)\
**Post date:** [October 29, 2025, 5:44pm UTC](https://forum.inductiveautomation.com/t/find-tag-numbers-for-hach-wims-integration/111794/4 "2025-10-29T17:44:29Z")

</div>

Thank you, found it!