We are working with a tangled web of legacy projects and tags that have little to no documentation. I am trying to find a handful of tags that are logging history over an SQL database connection named something to the effect of "Machine_Data". There are lots of workcells in this database, each with its own dedicated table, and each table is actively recording all kinds of data - open time, amperage, fault codes, forces, you get the idea. Entries on these tables span back a couple years and are still logging data today.
This is all well and good, but we are in a position where we need to expand this capability out to some more workcells in our facility. Only problem is, for the life of me I can't find the tags in Ignition that are doing this. I'm wondering if I can summon a list of all tags that have history enabled. I wasn't able to search for active database connections to this Machine_Data database. I also did all kinds of searches for the table names, field names, workcell names, and so on. 0 results every time.
I'm just hoping some more experienced Ignition users out there might share how they would go about investigating this system. I'm relatively new to the software and feel like I'm missing something obvious.
If it's using the Tag Historian, then there should be a table named sqlth_te in your database that holds tag names for historical tags. As long as the retired column is NULL the tags are still active. To get the provider as well you can do a JOIN with sqlth_scinfo to match scid with sqlth_scinfo.id and then to sqlth_drv to match drvid to sqlth_drv.id.
EDIT: Missed a step in the JOIN. Query below:
SELECT provider, tagpath, created, retired
FROM sqlth_te JOIN sqlth_scinfo
ON scid = sqlth_scinfo.id
ON drvid = sqlth_drv.id
Wow! You just sent me down a rabbit hole. I found that sqlth_te table and everything. Those links are perfect. Thank you so much for the quality answer. I still have some investigating to do but I'm confident I'll be able to figure it out with all this...