# Where are alarm tables located and how are they created? **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [March 1, 2024, 7:13pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693 "2024-03-01T19:13:06Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Post date:** [March 1, 2024, 7:13pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/1 "2024-03-01T19:13:06Z")
I have an Ignition Gateway with multiple Database Connections to MySQL schemas. Some projects are set to one schema while other projects have their own schema. The behavior I am seeing is some of my alarms in one schema are being put into the tables of other schemas. Example: **ProjectA** is using database **connection A** which is tied to the **schema A**. **ProjectB** is using database **connection B** which is tied to the **schema B**. Alarms for **ProjectA** and **ProjectB** are ending up in tables **alarm\_event\_data** and **alarm\_events** tables in **schema B.** My expectation is that alarms for **ProjectA** would end up in **alarm\_event\_data** and **alarm\_events** in **schema A** however that is not the behavior I am observing. What I noticed is **ProjectA** did have **alarm\_event\_data** and **alarm\_events** in **schema A** and then a user created an alarm journal **schema B** and the tables moved over to **schema B**. I assume Ignition is taking care of much of this behavior in the background but I wanted to confirm. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [March 1, 2024, 7:29pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/2 "2024-03-01T19:29:16Z")
All alarms will go to all Journals, the difference will be in the filter setting of the journal Example: I have a datasource for items put in bypass. Only items that match that filter actually go to the journal. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/4/24c819aa524d484b2de367f3391b0d3d9d9133ae.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 1, 2024, 7:31pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/3 "2024-03-01T19:31:22Z")
What Jordan said. But also, your description suggests you think alarms are part of projects. They are part of **tags** , which are outside of all projects. ---
**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Post date:** [March 1, 2024, 7:35pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/4 "2024-03-01T19:35:24Z")
Well typically all my projects go to the same database schema. This is the first customer I've seen who is making a new schema for every project (not my recommendation to them). Is there a way to keep a projects alarms within that projects schema? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 1, 2024, 7:39pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/5 "2024-03-01T19:39:39Z")
> [@bmeyers](#): > > a projects alarms within that projects schema? No, because alarms aren't associated with projects. You **must** use filters in the journals to select the tag hierarchies you think belong to a particular project. Consider defining a separate tag provider per project. That will simplify the filters. ---
**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Post date:** [March 1, 2024, 7:41pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/6 "2024-03-01T19:41:21Z")
Yes, I know they aren't actually a part of the project. When I say a "project's alarms" I mean the alarms I am associating with a particular project and by extension a "project's schema". ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 1, 2024, 7:42pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/7 "2024-03-01T19:42:26Z")
> [@bmeyers](#): > > the alarms I am associating with a particular project What does that mean? How would Ignition know that you are "associating" an alarm with a project? ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [March 1, 2024, 7:44pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/8 "2024-03-01T19:44:11Z")
Dang. My suggestion was going to be to whoop them like they had dressed up as a piñata for Halloween. Any way you look at it, though, the filter is what you will need to use to 'define' alarms to a project. ---
**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Post date:** [March 1, 2024, 7:48pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/9 "2024-03-01T19:48:58Z")
In this screenshot what is causing this particular alarm to be routed to the tables in Schema B versus Schema A? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/5/75a85ec4e673476bb4d32501e5c63fedeab3ceed.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 1, 2024, 7:51pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/10 "2024-03-01T19:51:34Z")
Nothing there decides where the alarm is journaled. It is an alarm on a tag. It "belongs" to the gateway as a whole, not to a project. The alarm journal configuration that Jordan pointed out is in the gateway web interface, and dictates what journal is connected to what database. Not related to any project, and not configurable in the designer. ---
**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Post date:** [March 1, 2024, 7:53pm UTC](https://forum.inductiveautomation.com/t/where-are-alarm-tables-located-and-how-are-they-created/86693/11 "2024-03-01T19:53:40Z")
I see. That helped make things click in my head.