# Sql Tag Historian List

**URL:** <https://forum.inductiveautomation.com/t/sql-tag-historian-list/5892>\
**Category:** Ignition\
**Created:** [February 19, 2013, 7:11am UTC](https://forum.inductiveautomation.com/t/sql-tag-historian-list/5892 "2013-02-19T07:11:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![WKetcham](https://avatars.discourse-cdn.com/v4/letter/w/c57346/32.png) [@WKetcham](https://forum.inductiveautomation.com/u/WKetcham)\
**Post date:** [February 19, 2013, 7:11am UTC](https://forum.inductiveautomation.com/t/sql-tag-historian-list/5892/1 "2013-02-19T07:11:34Z")

</div>

Is there a scripting function to return a list of all the tags (tag paths) that are logged using the SQL Tags Historian. I couldn’t find it in the manual.

Thanks,

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [February 20, 2013, 1:18am UTC](https://forum.inductiveautomation.com/t/sql-tag-historian-list/5892/2 "2013-02-20T01:18:59Z")

</div>

No, but you can query the sqlth\_te table in the database to find all of the tags that are not retired:`SELECT * FROM sqlth_te WHERE retired IS NULL`