# Merging alarm journals from two systems?

**URL:** <https://forum.inductiveautomation.com/t/merging-alarm-journals-from-two-systems/53596>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [November 30, 2021, 11:23pm UTC](https://forum.inductiveautomation.com/t/merging-alarm-journals-from-two-systems/53596 "2021-11-30T23:23:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kcabatic](https://avatars.discourse-cdn.com/v4/letter/k/b19c9b/32.png) [@kcabatic](https://forum.inductiveautomation.com/u/kcabatic)\
**Post date:** [November 30, 2021, 11:23pm UTC](https://forum.inductiveautomation.com/t/merging-alarm-journals-from-two-systems/53596/1 "2021-11-30T23:23:58Z")

</div>

Hello,

We have two independent systems; where only one is considered the system of record at any given time. Since they behave as independent systems they have their own alarm journals.

Is there a way to merge two alarm journals into a single table for analytics? Some of out initial ideas:

- use a script to scrape the journals from both systems and save it into a single table.
- add a new journal to both systems that point to same database/table. (Not sure if there would be collisions between the gateways though)

Open to thoughts on alternative methods?

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [November 30, 2021, 11:46pm UTC](https://forum.inductiveautomation.com/t/merging-alarm-journals-from-two-systems/53596/2 "2021-11-30T23:46:26Z")

</div>

Same database just different tables? You should be able to query across both. I doubt that you could use the alarm journal viewer but you should be able to do a report etc…

Edit: original reply via phone. Fixed grammer