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

**URL:** <https://forum.inductiveautomation.com/t/how-to-find-which-tags-are-using-a-certain-db-connection-historian/99385>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [December 3, 2024, 9:37pm UTC](https://forum.inductiveautomation.com/t/how-to-find-which-tags-are-using-a-certain-db-connection-historian/99385 "2024-12-03T21:37:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [December 3, 2024, 9:37pm UTC](https://forum.inductiveautomation.com/t/how-to-find-which-tags-are-using-a-certain-db-connection-historian/99385/1 "2024-12-03T21:37:48Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\
**Post date:** [December 3, 2024, 9:40pm UTC](https://forum.inductiveautomation.com/t/how-to-find-which-tags-are-using-a-certain-db-connection-historian/99385/2 "2024-12-03T21:40:47Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [December 3, 2024, 9:54pm UTC](https://forum.inductiveautomation.com/t/how-to-find-which-tags-are-using-a-certain-db-connection-historian/99385/3 "2024-12-03T21:54:35Z")

</div>

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](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/3/439b53da8c8d1588c1ba1272fbfbe7ae91325bff.png)