How to find which Tags are using a certain DB connection/Historian?

Ignition
1

I am in the process of migrating from MySQL to MSSQL, and I used the Tag Report Tool to track down which MySQL schemas were active for the Historical data... Apparently, I missed at least one tag, so when I removed the schema from MySQL, data forwarding errors began to rise. The Logs don't say which tag has an issue, so is there a place to look besides manually scraping through the list of tags?

Also, the tags that use the now defunct schema don't indicate an error, so that tells me there is no feedback from the Historian to the Tag proper that there could be a problem with the Historian DB Connection, correct?

2

Are you having issues with the recording of data or the retrieval of data. If having issues with recording, create a new DB with the same name as the old Historian connection and see what tags get added to the DB.

3

Recording data. I discovered I could search for a Storage Provider in the Tag Report Tool. I found two tags trying to write to the removed Historian DB.

image
image479×107 3.19 KB