We have UDT's defined and created tags based on these UDT's. There used to be a parameter in a UDT that had its data 'overridden' at the tag level. This parameter no longer exists so we are trying to pull the old values from a backup. These tags are stored in SQL, but I can't find where in the tables the tag parameters would be stored.
is it not in TagConfig?
Where would TagConfig be? There is no table called TagConfig in the History Provider database.
Tag configuration is stored in Ignition's internal database, a SQLite file on disk (in 8.1 and prior versions). The historian's tables only store history data.
You should not attempt to read or modify the data in this config.idb file; I would recommend contacting support if you want to attempt to recover old data.
this is surprising coming from the kindling devs who gave us read queries on the IDB
(Although, for sure, writing to the IDB is a here be dragons location)
I found some hints of what I'm looking for in TagConfig in config.idb but I have no clue how this relates back to actual tags. I'll need to pull a backup from further back before I reach out to support because this doesn't have the data I need.
Kindling was originally developed as a tool to aid support reps, and is open source/publicly available precisely for people like you who understand the limits of a support contract and generally know what's "safe" ground to tread on.
Kindling is capable of opening any SQLite file, and we use SQLite for the metrics and log file dumps you'll get in a diagnostic backup. That you also get full read access to the underlying SQLite structure is a deliberate choice, but not one that I'd encourage users to exercise carte blanche.
1 Like
Valid, thanks for clarifying