# Perspective Alarm journal export

**URL:** <https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 20, 2023, 2:43pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704 "2023-04-20T14:43:29Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [April 20, 2023, 2:43pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704/1 "2023-04-20T14:43:30Z")

</div>

Hello,

Is there a way to export to excel the content of a Perspective Alarm journal?

Thanks.

---

<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:** [April 20, 2023, 3:06pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704/2 "2023-04-20T15:06:11Z")

</div>

you will have to use:

```auto
system.alarm.queryJournal

```

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [April 20, 2023, 3:15pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704/3 "2023-04-20T15:15:49Z")

</div>

> [@mazeyrat](#):
>
> `system.alarm.queryJournal`

This can be used to produce a dataset. From there, it should be possible to use [system.dataset.toCSV](https://docs.inductiveautomation.com/display/DOC81/system.dataset.toCSV) to produce a CSV file. Then, to save it to the computer, you can use [system.perspective.download](https://docs.inductiveautomation.com/display/DOC81/system.perspective.download).

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [April 20, 2023, 3:25pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704/4 "2023-04-20T15:25:29Z")

</div>

That does not seems wasy to retreive a list of alarms containing the active duration of each alarms..?

---

<div class="post-metadata">

**Author:** ![Arnaud\_Declerck](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arnaud_declerck/32/44872_2.png) [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\
**Post date:** [April 20, 2023, 6:03pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704/5 "2023-04-20T18:03:39Z")

</div>

Hi @vrautomation,

each couple of alarms message (Active, cleared) has a common unique id. you could use those to group the same alarm and substract active timestamp from cleared timestamp (You will maybe need to convert it to the format you want (seconds, minutes,...). From my part i would rather use sql query instead of the system.alarm.queryJournal method.  
A good start would be the queries used inside this ressource. [Ignition Exchange | Inductive Automation](https://inductiveautomation.com/exchange/57/overview) would need some modification in function of the sql server you're using. This can return a dataset and you can export dataset to excel with a scripting function.

Regards

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [April 20, 2023, 7:18pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704/6 "2023-04-20T19:18:26Z")

</div>

I did it in SQL. It's working.

But I think there should have a buil-in option to export to excel any data shown in any table in Perspective or Vision.

Thanks.

---

<div class="post-metadata">

**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:** [April 20, 2023, 8:00pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-journal-export/72704/7 "2023-04-20T20:00:23Z")

</div>

> [@vrautomation](#):
>
> But I think there should

That's what the feature request site is for.