# Export Alarm Journal to Table and include Event Value

**URL:** <https://forum.inductiveautomation.com/t/export-alarm-journal-to-table-and-include-event-value/39022>\
**Category:** General Discussion\
**Created:** [September 24, 2020, 2:05pm UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-table-and-include-event-value/39022 "2020-09-24T14:05:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikecrawford](https://avatars.discourse-cdn.com/v4/letter/m/5daacb/32.png) [@mikecrawford](https://forum.inductiveautomation.com/u/mikecrawford)\
**Post date:** [September 24, 2020, 2:05pm UTC](https://forum.inductiveautomation.com/t/export-alarm-journal-to-table-and-include-event-value/39022/1 "2020-09-24T14:05:40Z")

</div>

Hello  
I have successfully exported the Alarm Journal based on Date Range into a table where I can then export to Excel. However, I have the EventId, Source, Displaypath, EventTime, EventState, Priority, and IsSystemEvent in the table. I would like to add “Event Value” as well. I have tried different variations but none are successful. Your assistance would be appreciated. We would like to have the value that was not only changed but what it was changed to.

start = event.source.parent.getComponent(‘Date Range’).startDate  
end = event.source.parent.getComponent(‘Date Range’).endDate  
journal = system.alarm.queryJournal(startDate=start, endDate=end).getDataset()

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