How to cross reference tag history in ignition with a particular tagid in database

Ignition
1

Good morning,

Because we are generating PowerBI reports based on historical ignition data, I am finding the need for a methodical approach to cross reference a particular tag's history from Ignition, to its database tagID. Is there a way to do this?

Thank you in advance,

Bogdan

2

I think you're asking about the data that is stored in "sqlth_te".

I wouldn't recommend querying Ignition Historian data in SQL because it is usually pretty inelegant to do that with tables partitioning, etc.

I would first look if these methods give you the functionality you're looking for:
https://docs.inductiveautomation.com/display/DOC81/system.tag.queryTagHistory
https://docs.inductiveautomation.com/display/DOC81/system.tag.queryTagCalculations

3

Generally speaking, the best service-agnostic approach is a Webdev endpoint that calls system.tag.queryTagHistory and returns a JSON dump of the data you're interested in. That's pretty straightforward to ingest in tools like PowerBI, Tableau, etc.

2 Likes