Shared Alarm database

Ignition
1

If I am using a MS-SQL database based alarm journal, can I have mutiple servers using it?
IE does ignition properly context things in the two tables?
I know that alarm_events stores using provider and tag in the source column, and the alarm_event_data and alarm_events are linked by ID=ID,
ID is identity in alarm_events, and not identity on alarm_event_data, so is the basic sequence

insert into alarm_events
select scope(identity())
insert into alarm_event_data id=scope_identity

that would mean that it doesn't matter if mutiple servers are using the same database, I believe...
Thanks!

1 Like
2

You are correct, multiple servers can use the same journal. Every alarm event in the journal has a unique id, the source column is how you'd know where it originated.

If you needed to differentiate the tables between servers for whatever reason, there are also settings to adjust Alarm Journal Table names in the advanced properties. (An example reason why that was needed is in this thread)