# Alarm Status Table and Alarm Journal Components

**URL:** <https://forum.inductiveautomation.com/t/alarm-status-table-and-alarm-journal-components/29873>\
**Category:** Ignition\
**Created:** [November 12, 2019, 1:26pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-and-alarm-journal-components/29873 "2019-11-12T13:26:18Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![bbranison](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@bbranison](https://forum.inductiveautomation.com/u/bbranison)\
**Post date:** [April 22, 2020, 5:17pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-and-alarm-journal-components/29873/4 "2020-04-22T17:17:31Z")

</div>

Below is the solution I ended up using for this:

from com.inductiveautomation.ignition.common.alarming.config import CommonAlarmProperties

range = event.source.parent.getComponent(‘Date Range’)  
table = system.alarm.queryJournal(journalName=‘Journal’, startDate = range.startDate, endDate = range.endDate, includeSystem=True, includeData=True)

ackUserData = []  
for row in table:  
ackUserData.append(str(row.get(CommonAlarmProperties.AckUserName)))  
ackNotes = []  
for row in table:  
ackNotes.append(str(row.get(CommonAlarmProperties.AckNotes)))   
nameData = []   
for row in table:  
nameData.append(str(row.get(CommonAlarmProperties.Name)))

tableData = table.getDataset()  
tableData = system.dataset.addColumn(tableData,ackUserData,‘Ack User’,type(str()))  
tableData = system.dataset.addColumn(tableData,ackNotes,‘Ack Notes’,type(str()))  
tableData = system.dataset.addColumn(tableData,nameData,‘Label’,type(str()))

filePath = system.dataset.exportExcel(“data.xls”, 1, tableData)  
if filePath != None:  
system.net.openURL(“file://”+filePath)

---

_[View the full topic](https://forum.inductiveautomation.com/t/alarm-status-table-and-alarm-journal-components/29873)._