# How many tags with history? (Historian statisics)

**URL:** <https://forum.inductiveautomation.com/t/how-many-tags-with-history-historian-statisics/62374>\
**Category:** Ignition\
**Created:** [July 27, 2022, 10:08pm UTC](https://forum.inductiveautomation.com/t/how-many-tags-with-history-historian-statisics/62374 "2022-07-27T22:08:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![A\_Power](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@A\_Power](https://forum.inductiveautomation.com/u/A_Power)\
**Post date:** [July 27, 2022, 10:08pm UTC](https://forum.inductiveautomation.com/t/how-many-tags-with-history-historian-statisics/62374/1 "2022-07-27T22:08:44Z")

</div>

Hi All,

Sorry for what may be a dumb question.

How does quickly find a total number of tags in a project with history enabled?  
I can’t find a setting or a page with a summary.

Note our site is cyclical in its operation so the aggregate count on the gateway doesn’t help when half the plant isn’t running- I want to know how many total.

Is it a scripting challenge? An SQL Challenge? (Both my weak points)

Thanks in advance

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [July 27, 2022, 10:22pm UTC](https://forum.inductiveautomation.com/t/how-many-tags-with-history-historian-statisics/62374/2 "2022-07-27T22:22:01Z")

</div>

Easiest is to select count on sqlth\_te where retired is NULL  
In whichever database you are storing history.