# Ignition Historian tagpath

**URL:** <https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986>\
**Category:** Ignition\
**Created:** [March 27, 2024, 5:16pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986 "2024-03-27T17:16:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ronny\_James](https://avatars.discourse-cdn.com/v4/letter/r/ec9cab/32.png) [@Ronny\_James](https://forum.inductiveautomation.com/u/Ronny_James)\
**Post date:** [March 27, 2024, 5:16pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986/1 "2024-03-27T17:16:27Z")

</div>

Is there a way to extract the PLC tag from the Ignition Historian tagpath?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/0/4047bfa659f23c5a2ca87f05c4089164774b017b.png)

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 27, 2024, 5:42pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986/2 "2024-03-27T17:42:50Z")

</div>

What do you mean by PLC tag name? The OPC Item Path? The last component of the tag path?

---

<div class="post-metadata">

**Author:** ![earnhartj84](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/earnhartj84/32/29405_2.png) [@earnhartj84](https://forum.inductiveautomation.com/u/earnhartj84)\
**Post date:** [March 27, 2024, 7:37pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986/3 "2024-03-27T19:37:07Z")

</div>

OPCItemPath

ns=1;s=[PLC name] #tag name. (data type: String)

---

<div class="post-metadata">

**Author:** ![Ronny\_James](https://avatars.discourse-cdn.com/v4/letter/r/ec9cab/32.png) [@Ronny\_James](https://forum.inductiveautomation.com/u/Ronny_James)\
**Post date:** [March 27, 2024, 7:50pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986/4 "2024-03-27T19:50:05Z")

</div>

Yes, the OPC item.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 27, 2024, 7:55pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986/5 "2024-03-27T19:55:57Z")

</div>

In what context do you need to derive this? You obviously are out of luck if you're just looking at a tag path like your screenshot.

---

<div class="post-metadata">

**Author:** ![Ronny\_James](https://avatars.discourse-cdn.com/v4/letter/r/ec9cab/32.png) [@Ronny\_James](https://forum.inductiveautomation.com/u/Ronny_James)\
**Post date:** [March 28, 2024, 6:34pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986/6 "2024-03-28T18:34:48Z")

</div>

We have two historian databases (Wonderware Historian & Ignition Historian) logging the same PLC data. I need to associate the WW Historian SQL table with the Ignition Historian SQL table. I was hoping to join the two tables on the OPC item which is exposed directly in the WW Historian table.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 28, 2024, 6:56pm UTC](https://forum.inductiveautomation.com/t/ignition-historian-tagpath/87986/7 "2024-03-28T18:56:46Z")

</div>

Ignition's historian doesn't log OPC Items. It logs Ignition tags, which may or may not be an OPC item, and which have names that are not required to have anything in common with the OPC item name. You aren't going to be able to do this purely at the DB level.