# Underlying dataset of the alarm journal and alarm status component

**URL:** <https://forum.inductiveautomation.com/t/underlying-dataset-of-the-alarm-journal-and-alarm-status-component/15651>\
**Category:** Ignition\
**Created:** [October 12, 2017, 10:34am UTC](https://forum.inductiveautomation.com/t/underlying-dataset-of-the-alarm-journal-and-alarm-status-component/15651 "2017-10-12T10:34:05Z")\
**Posts on this page:** 5\
**Page:** 1

<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:** [October 12, 2017, 10:34am UTC](https://forum.inductiveautomation.com/t/underlying-dataset-of-the-alarm-journal-and-alarm-status-component/15651/1 "2017-10-12T10:34:05Z")

</div>

I’m looking for the underlying dataset of the alarm journal and alarm status component to be able to export visible data to excel (I don’t want to query a second time from script with system.alarm.queryStatus for example to retrieve datat which are probably ever available in the component)  
Any Idea to access to it ???

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [October 13, 2017, 6:16pm UTC](https://forum.inductiveautomation.com/t/underlying-dataset-of-the-alarm-journal-and-alarm-status-component/15651/2 "2017-10-13T18:16:11Z")

</div>

I’m not sure exactly what you’re looking for, but perhaps looking [here](http://files.inductiveautomation.com/sdk/javadoc/ignition79/793/com/inductiveautomation/factorypmi/application/components/AlarmJournalTable.html) and [here](http://files.inductiveautomation.com/sdk/javadoc/ignition79/793/com/inductiveautomation/factorypmi/application/components/AlarmStatusTable.html) will help.

---

<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:** [October 13, 2017, 7:09pm UTC](https://forum.inductiveautomation.com/t/underlying-dataset-of-the-alarm-journal-and-alarm-status-component/15651/3 "2017-10-13T19:09:29Z")

</div>

Not exactly what I’m looking for. Often some component properties are not directly exposed in Ignition, but you can access to them …I hope to be able to access to the dataset of the JTable used inside the alarms components, in order to export it to xls format.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 13, 2017, 8:05pm UTC](https://forum.inductiveautomation.com/t/underlying-dataset-of-the-alarm-journal-and-alarm-status-component/15651/4 "2017-10-13T20:05:57Z")

</div>

Unfortunately, I don’t think the alarm journal/status tables actually return a clean Ignition dataset - it looks like it’s an object more similar to the alarm event list returned by system.alarm.queryStatus, but without the convenience `.getDataset()` method. And even then, it’s only accessible with some pretty fragile `getComponent()` nested calls.

---

<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:** [October 13, 2017, 8:19pm UTC](https://forum.inductiveautomation.com/t/underlying-dataset-of-the-alarm-journal-and-alarm-status-component/15651/5 "2017-10-13T20:19:43Z")

</div>

Thanks @paul-griffith, no problem I will continue to use the built-in alarm script functions to query with the same filter parameters and export the data.