Merging alarm journals from two systems?

Ignition
,
1

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?

2

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

1 Like