# Querying Ignition Historian from SSRS **URL:** \ **Category:** Ignition\ **Created:** [July 26, 2024, 2:10pm UTC](https://forum.inductiveautomation.com/t/querying-ignition-historian-from-ssrs/93793 "2024-07-26T14:10:10Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Aron\_Grzywaczewski](https://avatars.discourse-cdn.com/v4/letter/a/439d5e/32.png) [@Aron\_Grzywaczewski](https://forum.inductiveautomation.com/u/Aron_Grzywaczewski)\ **Post date:** [July 26, 2024, 2:10pm UTC](https://forum.inductiveautomation.com/t/querying-ignition-historian-from-ssrs/93793/1 "2024-07-26T14:10:10Z")
Hi, My understanding of the Ignition Historian is that it creates multiple data partitions in the Historian database for better performance. Is there an easy way of querying the historian data from SSRS like there is in the Ignition SCADA reporting system? e.g. querying against one table and without worrying about all the other tables and their relation. Is there a historian adapter for external interfaces? ---
**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:** [July 26, 2024, 2:15pm UTC](https://forum.inductiveautomation.com/t/querying-ignition-historian-from-ssrs/93793/2 "2024-07-26T14:15:22Z")
> [@Aron\_Grzywaczewski](#): > > multiple data partitions in the Historian database for better performance No, the partitions are time-based for easy pruning of old data (when enabled). > [@Aron\_Grzywaczewski](#): > > Is there a historian adapter for external interfaces? No, but the schema is in the docs. Since there's no guarantee that the schema won't change at some point, it is strongly recommended you use Ignition's scripting API for historian queries. If you need external access, consider deploying a web API with the WebDev module.