# Alarm Journal and Status Component: can we easily retrieve any datasets from this table?

**URL:** <https://forum.inductiveautomation.com/t/alarm-journal-and-status-component-can-we-easily-retrieve-any-datasets-from-this-table/33932>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 14, 2020, 10:00pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-and-status-component-can-we-easily-retrieve-any-datasets-from-this-table/33932 "2020-04-14T22:00:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tmahaffey](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tmahaffey/32/30949_2.png) [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\
**Post date:** [April 14, 2020, 10:00pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-and-status-component-can-we-easily-retrieve-any-datasets-from-this-table/33932/1 "2020-04-14T22:00:28Z")

</div>

As my title suggests, I'm wondering if there is a way to get a dataset from the results stored in these tables? I see some older posts from 2017 here:

> [@Underlying dataset of the alarm journal and alarm status component](http://forum.inductiveautomation.com/t/underlying-dataset-of-the-alarm-journal-and-alarm-status-component/15651):
>
> 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 ???

[http://files.inductiveautomation.com/sdk/javadoc/ignition79/793/com/inductiveautomation/factorypmi/application/components/AlarmJournalTable.html](http://files.inductiveautomation.com/sdk/javadoc/ignition79/793/com/inductiveautomation/factorypmi/application/components/AlarmJournalTable.html)

My hastily conducted searches make me think it's possible, but requires quite a bit of custom scripting. It sure would be nice get the data out of these tables. Thanks for any help.

---

<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:** [April 14, 2020, 11:38pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-and-status-component-can-we-easily-retrieve-any-datasets-from-this-table/33932/2 "2020-04-14T23:38:31Z")

</div>

Hmm, well you should be able to get the `table` object from the alarm journal according to the javadocs, however when I tried, I get an error reporting the journal object doesn’t have an attribute called `table`. I’ll leave this for someone who actually knows what they’re talking about in terms of Java 🙂 @pturmel @paul-griffith

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8539a8092a548b98e717882346ed98fd806c8c1e.png)  
If you can get the table object, then it has some methods to get the rows and columns. You might need to pack it into the dataset yourself though.

---

<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:** [April 15, 2020, 12:04am UTC](https://forum.inductiveautomation.com/t/alarm-journal-and-status-component-can-we-easily-retrieve-any-datasets-from-this-table/33932/3 "2020-04-15T00:04:46Z")

</div>

My answer hasn’t really changed since the original thread 🙂

The `table` field on the class is `protected`; Python doesn’t have true access modifiers, but Java does - `protected` means only subclasses have access to the field, which makes it useless to any scripts you can write in Ignition. Technically, reflection lets you bypass that check, but that’s an exercise for the reader.