# Archive and Prune Alarm Journal for Auditing

**URL:** <https://forum.inductiveautomation.com/t/archive-and-prune-alarm-journal-for-auditing/97061>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [October 10, 2024, 3:37am UTC](https://forum.inductiveautomation.com/t/archive-and-prune-alarm-journal-for-auditing/97061 "2024-10-10T03:37:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SWoollett](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@SWoollett](https://forum.inductiveautomation.com/u/SWoollett)\
**Post date:** [October 10, 2024, 3:37am UTC](https://forum.inductiveautomation.com/t/archive-and-prune-alarm-journal-for-auditing/97061/1 "2024-10-10T03:37:33Z")

</div>

We have recently rolled out Ignition in our facility. I'm now seeing that our AlarmJournal query is taking a long time to complete and I'm seeing errors on the gateway.

We currently have about 1 years worth of alarms stored and require to maintain a total of 7 years worth for auditing.

Does anyone have a solution where we are able to maintain ~6 months live available through ignition and once the data is older than that export it to another database to maintain the 7 years worth of cold data.

similar to the prune feature, but rather than deleting, Exporting.

---

<div class="post-metadata">

**Author:** ![SWoollett](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@SWoollett](https://forum.inductiveautomation.com/u/SWoollett)\
**Post date:** [October 10, 2024, 3:44am UTC](https://forum.inductiveautomation.com/t/archive-and-prune-alarm-journal-for-auditing/97061/2 "2024-10-10T03:44:08Z")

</div>

Well I did some more thinking in the past 5 minutes...  
I don't see why I couldn't set up two alarm journal profiles, one with the prune age set to 6 months the other with its prune age set to 7 years.

Then only reference the 6 month journal in the app

---

<div class="post-metadata">

**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:** [October 10, 2024, 10:59am UTC](https://forum.inductiveautomation.com/t/archive-and-prune-alarm-journal-for-auditing/97061/3 "2024-10-10T10:59:17Z")

</div>

You should probably also have a database administrator examine your instance for tuning and query analysis. You probably need more careful indexing.