Find all tags that have history enabled

[Bushmatic]

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.

[Felipe_CRM]

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
JOIN sqlth_drv
ON drvid = sqlth_drv.id

[Felipe_CRM]

The built-in solution seems to be the Tag Report Tool, as mentioned in this topic:

List of All Historical Tags

New to Ignition so I apologize if this is an easy one... I have an Ignition SCADA delivered from the vendor and want to get a full list of the tags used that are configured for Tag History. I can't seem to find a way to do this in the Designer as the tag export doesn't give the history parameters. Is there a way to list all the tags that have "History Enabled" and ideally what the history parameters are? I have thousands of tags so going manually through the Tag Browser will take years.

Just for completeness's sake, there's also a script in this topic:

How to find all tags configured with tag history?

Try running the following code in your script console. Note that if your tags exist under a tag provider other than ‘[default]’, you’ll need to change line 5 to reflect that. If there are thousands of tags with history configured, the printed results may be too long to see them all in the script console, so they may need to be written to giant string which is saved directly to your workstation as a .txt file once the for loop has completed. Edit: I should probably state that the following will …

[Bushmatic]

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...

[Felipe_CRM]

If you're on 8.1.19 or later, that Tag Report Tool is honestly really nice. It took about 5 seconds to find all the historical tags on a given provider:

Only issue seems to be that it can only do one tag provider at a time, unlike the SQL method.

[Bushmatic]

We are unfortunately on version 8.1.18! Maybe it is time for an update. That looks like a really useful tool.