# Shared Alarm database

**URL:** <https://forum.inductiveautomation.com/t/shared-alarm-database/108492>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 15, 2025, 4:08pm UTC](https://forum.inductiveautomation.com/t/shared-alarm-database/108492 "2025-07-15T16:08:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gregory.sachs](https://avatars.discourse-cdn.com/v4/letter/g/e47774/32.png) [@gregory.sachs](https://forum.inductiveautomation.com/u/gregory.sachs)\
**Post date:** [July 15, 2025, 4:08pm UTC](https://forum.inductiveautomation.com/t/shared-alarm-database/108492/1 "2025-07-15T16:08:16Z")

</div>

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

```python
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!

---

<div class="post-metadata">

**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\
**Post date:** [July 16, 2025, 10:51pm UTC](https://forum.inductiveautomation.com/t/shared-alarm-database/108492/2 "2025-07-16T22:51:36Z")

</div>

You are correct, multiple servers can use the same journal. Every alarm event in the [journal](https://www.docs.inductiveautomation.com/docs/8.1/platform/alarming/alarm-journal#database-table-definitions) 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](https://forum.inductiveautomation.com/t/servername-in-alarm-events-table/92125))