# Pulling Alarm Tag Information

**URL:** <https://forum.inductiveautomation.com/t/pulling-alarm-tag-information/88165>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [April 1, 2024, 5:32pm UTC](https://forum.inductiveautomation.com/t/pulling-alarm-tag-information/88165 "2024-04-01T17:32:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![scadafan](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@scadafan](https://forum.inductiveautomation.com/u/scadafan)\
**Post date:** [April 1, 2024, 5:32pm UTC](https://forum.inductiveautomation.com/t/pulling-alarm-tag-information/88165/1 "2024-04-01T17:32:04Z")

</div>

I have a bunch of tags that have alarms on them and I would like a way to get all the information for it.

I know there is the tag report tool. However, when I export the tag with alarms it gives me one big column with all the information on there as a json and all the tags have different types of alarms on them. Is there a simpler way to get all the tags and the information for them which is nicely formatted in Excel?

---

<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:** [April 1, 2024, 5:46pm UTC](https://forum.inductiveautomation.com/t/pulling-alarm-tag-information/88165/2 "2024-04-01T17:46:35Z")

</div>

No, Excel doesn't really have a "native" way to show data that has nested data. You would need a custom Excel export script of some kind.

---

<div class="post-metadata">

**Author:** ![scadafan](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@scadafan](https://forum.inductiveautomation.com/u/scadafan)\
**Post date:** [April 1, 2024, 5:57pm UTC](https://forum.inductiveautomation.com/t/pulling-alarm-tag-information/88165/3 "2024-04-01T17:57:10Z")

</div>

Any idea where I could get an example of one or even a python script that might do the exporting for me?

---

<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:** [April 1, 2024, 6:00pm UTC](https://forum.inductiveautomation.com/t/pulling-alarm-tag-information/88165/4 "2024-04-01T18:00:35Z")

</div>

I don't have one handy, but there are a number of topics here that show how to use the Apache POI libraries to create Excel files. Typically to produce customized dataset exports. Use the data from `system.tag.getConfiguration()` in place of a dataset.

---

<div class="post-metadata">

**Author:** ![scadafan](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@scadafan](https://forum.inductiveautomation.com/u/scadafan)\
**Post date:** [April 2, 2024, 4:32pm UTC](https://forum.inductiveautomation.com/t/pulling-alarm-tag-information/88165/5 "2024-04-02T16:32:26Z")

</div>

Sorry to revive this again. But I still can't seem to figure out a simple way of doing this. When I export all the tags using the Tag Report Tool it shows the alarm column like this:

```auto
[{'mode': 'Above Setpoint', 'setpointA': 999.0, 'name': 'High', 'enabled': '[~]Oper/test1/LineRunning'}]
[{'mode': 'Above Setpoint', 'setpointA': 999.0, 'name': 'High', 'enabled': '[~]Oper/test1/LineRunning'}]
[{'mode': 'Above Setpoint', 'setpointA': 999.0, 'name': 'High', 'enabled': '[~]Oper/test1/LineRunning'}]
[{'mode': 'Above Setpoint', 'setpointA': 999.0, 'name': 'High', 'enabled': '[~]Oper/test1/LineRunning'}]
[{'mode': 'Above Setpoint', 'setpointA': 999.0, 'name': 'High', 'enabled': '[~]Oper/test1/LineRunning'}]
[{'mode': 'Above Setpoint', 'setpointA': 999.0, 'name': 'High', 'enabled': '[~]Oper/test1/LineRunning'}]
[{'mode': 'Above Setpoint', 'setpointA': 999.0, 'name': 'High', 'enabled': '[~]Oper/test1/LineRunning'}]

```

Rather then having it like this I would like to it show up in Columns where it just gives me tag path, label, and conditions for alarm maybe. How could I do this? Python scripting, or something built into Ignition would be great too.

---

<div class="post-metadata">

**Author:** ![Arnaud\_Declerck](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arnaud_declerck/32/44872_2.png) [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\
**Post date:** [April 2, 2024, 5:57pm UTC](https://forum.inductiveautomation.com/t/pulling-alarm-tag-information/88165/6 "2024-04-02T17:57:49Z")

</div>

Hi @scadafan

Here some example of exchange resource working with alarm.

> **[Ignition Exchange](https://inductiveautomation.com/exchange/2286/overview)**
>
> Discover, share, and download community made Ignition resources in collaboration with your organization or the Ignition community.

> **[Ignition Exchange](https://inductiveautomation.com/exchange/2606/overview)**
>
> Discover, share, and download community made Ignition resources in collaboration with your organization or the Ignition community.

None of those can do a export to excel, but it give you a pretty good idea how to get the alarms info of tags. Then it's just a matter to program the export of those data.

Regards