# OPC UA Historical Access **URL:** \ **Category:** Ignition Early Access\ **Created:** [March 1, 2019, 10:25pm UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009 "2019-03-01T22:25:08Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![paul.bouillon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.bouillon/32/7980_2.png) [@paul.bouillon](https://forum.inductiveautomation.com/u/paul.bouillon)\ **Post date:** [March 1, 2019, 10:25pm UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009/1 "2019-03-01T22:25:08Z")
Hey, Was wondering if historical access to OPC tags would be supported in v8. Would be huge if we didn’t have to backfill data into our OSISoft/PI corporate historian – and just leverage the functionality that is planned for OPC UA directly. Thanks in advance! -Paul ---
**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 1, 2019, 10:55pm UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009/2 "2019-03-01T22:55:10Z")
It won’t be part of Ignition 8.0 and I doubt this will be implemented any time soon. There’s very little demand (although I’m counting your request) and it’s a significant amount of effort to implement. ---
**Author:** ![paul.bouillon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.bouillon/32/7980_2.png) [@paul.bouillon](https://forum.inductiveautomation.com/u/paul.bouillon)\ **Post date:** [March 4, 2019, 10:48pm UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009/3 "2019-03-04T22:48:36Z")
Thanks Kevin for the (amazingly) quick reply. Yes – please count this as a request 🙂 I imagine there will be much more demand for this as UA becomes more widely adopted. Would be great to see… ---
**Author:** ![joe.friedrich](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/joe.friedrich/32/7505_2.png) [@joe.friedrich](https://forum.inductiveautomation.com/u/joe.friedrich)\ **Post date:** [March 5, 2019, 3:33pm UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009/4 "2019-03-05T15:33:29Z")
Kevin, Is this the kind of thing that should be posted on the [Ignition Features and Ideas page](https://inductiveautomation.canny.io/ignition-features-and-ideas)? ---
**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 5, 2019, 3:49pm UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009/5 "2019-03-05T15:49:09Z")
Never hurts to post it there. ---
**Author:** ![paul.bouillon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.bouillon/32/7980_2.png) [@paul.bouillon](https://forum.inductiveautomation.com/u/paul.bouillon)\ **Post date:** [March 5, 2019, 3:52pm UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009/6 "2019-03-05T15:52:34Z")
yep – I posted there too a while back 🙂 – was just curious what was in the works with the beta [https://inductiveautomation.canny.io/ignition-features-and-ideas/p/opc-ua-historical-access](https://inductiveautomation.canny.io/ignition-features-and-ideas/p/opc-ua-historical-access) ---
**Author:** ![mark.om](https://avatars.discourse-cdn.com/v4/letter/m/a87d85/32.png) [@mark.om](https://forum.inductiveautomation.com/u/mark.om)\ **Post date:** [May 8, 2020, 6:17am UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009/7 "2020-05-08T06:17:43Z")
Paul. How are you currently backfilling the data into Osisoft PI? ---
**Author:** ![paul.bouillon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.bouillon/32/7980_2.png) [@paul.bouillon](https://forum.inductiveautomation.com/u/paul.bouillon)\ **Post date:** [May 8, 2020, 11:24am UTC](https://forum.inductiveautomation.com/t/opc-ua-historical-access/23009/8 "2020-05-08T11:24:11Z")
Hi Mark, It can be done manually by inspecting a combination of the sql tables managed by the historian module – I would suggest taking a quick look at the SDK reference for these tables to better understand how they function: [https://docs.inductiveautomation.com/display/SE/Tag+History+Tables+Reference](https://docs.inductiveautomation.com/display/SE/Tag+History+Tables+Reference) Generally – you will need to inspect the following (names/etc may not be exact – going from memory here…) - sqlth\_te (find the id of the tag based on it’s TagPath within the historian db) - sqlth\_partitions (find the data table(s) for the time-range you’re after) - sqlt\_data\_x\_x\_x (this is the table returned for your time-range in question…use the “WHERE” clause to filter entries pertaining to your specific tag id) Hope this helps! -Paul PS – I think there is a more elegant way of doing this via the PI RDBMS interface – but I’m assuming you’re trying to fill the missing data that may have been captured via OPC-UA connector?)