Is there a way to extract the PLC tag from the Ignition Historian tagpath?
What do you mean by PLC tag name? The OPC Item Path? The last component of the tag path?
OPCItemPath
ns=1;s=[PLC name] #tag name. (data type: String)
Yes, the OPC item.
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.
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.
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.
3 Likes