# Perspective Alarm Journal Table - Show Alarm Duration

**URL:** <https://forum.inductiveautomation.com/t/perspective-alarm-journal-table-show-alarm-duration/76732>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 21, 2023, 7:41pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-table-show-alarm-duration/76732 "2023-07-21T19:41:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bronzebeard62](https://avatars.discourse-cdn.com/v4/letter/b/838e76/32.png) [@Bronzebeard62](https://forum.inductiveautomation.com/u/Bronzebeard62)\
**Post date:** [July 21, 2023, 7:41pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-table-show-alarm-duration/76732/1 "2023-07-21T19:41:28Z")

</div>

Using the Alarm Journal Table in Perspective, how can I show the duration that an alarm was active? I see that the Alarm Status Table component has a column I can choose called clearTime which would give me information on how long the alarm was active, but I can find no such thing on the Alarm Journal Table component. Does anyone have any solutions to this?

Thanks,

---

<div class="post-metadata">

**Author:** ![franklepkowski](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/franklepkowski/32/4808_2.png) [@franklepkowski](https://forum.inductiveautomation.com/u/franklepkowski)\
**Post date:** [July 22, 2023, 2:35am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-table-show-alarm-duration/76732/2 "2023-07-22T02:35:08Z")

</div>

Hello,

I think you could probably use a stored procedure or a query to get what you’re after. Give it start and end date parameters, and bind a table component to your result set.

Frank

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [July 22, 2023, 10:09am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-table-show-alarm-duration/76732/3 "2023-07-22T10:09:21Z")

</div>

This has always been a flaw in the alarm journal table components in both Vision and Perspective: they just show raw data directly from the journal table instead of pivoting event ids together to give you a row per alarm event Id with active/ack/shelved/clear times and then calculate time to clear. It's incredibly difficult for operators to use to analyse alarms. I don't use the default journal component for this reason and perform a query with a pivot to produce how it should be presented inside of a standard Table component. I added an idea from years ago to fix it 🤷

---

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [July 22, 2023, 11:15am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-table-show-alarm-duration/76732/4 "2023-07-22T11:15:55Z")

</div>

> **[Summarise Alarms in single rows in Alarm Journal Table (Vision &...](https://inductiveautomation.canny.io/ignition-features-and-ideas/p/summarise-alarms-in-single-rows-in-alarm-journal-table-vision-perspective)**
>
> At the moment, looking at a history of alarms is difficult to piece together when all the events associated with an alarm occur as all of these are reported on

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [July 22, 2023, 2:13pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-table-show-alarm-duration/76732/5 "2023-07-22T14:13:03Z")

</div>

Can you provide a sample query, please?