# Historian Data Features

**URL:** <https://forum.inductiveautomation.com/t/historian-data-features/3791>\
**Category:** Ignition\
**Created:** [December 21, 2011, 5:58pm UTC](https://forum.inductiveautomation.com/t/historian-data-features/3791 "2011-12-21T17:58:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nathanp10](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@nathanp10](https://forum.inductiveautomation.com/u/nathanp10)\
**Post date:** [December 21, 2011, 5:58pm UTC](https://forum.inductiveautomation.com/t/historian-data-features/3791/1 "2011-12-21T17:58:37Z")

</div>

I have a couple of feature suggestions for viewing and manipulating the data stored in the historian.

-View/export tag values with timestamps as they’re stored in the database. Right now if I want to get the actual values I need to write a big query to grab the data from the different partition tables in the database, which is kind of a pain. I attached a screenshot of PI SMT to illustrate what I was thinking of, a search interface with a spreadsheet view.  
-Add a value for a historized sql tag at a previous point in time. I don’t think this is possible currently except for inserting the data directly into the partition tables. It would be nice if we could do this through import or a scripting function.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/60340283271c1b7cd38b5085ee71989fdfaa4086.PNG)