# Displaying only the alarm name from alarm\_events on report

**URL:** <https://forum.inductiveautomation.com/t/displaying-only-the-alarm-name-from-alarm-events-on-report/106948>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [June 3, 2025, 11:12am UTC](https://forum.inductiveautomation.com/t/displaying-only-the-alarm-name-from-alarm-events-on-report/106948 "2025-06-03T11:12:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Steve\_Caulfield](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@Steve\_Caulfield](https://forum.inductiveautomation.com/u/Steve_Caulfield)\
**Post date:** [June 3, 2025, 11:12am UTC](https://forum.inductiveautomation.com/t/displaying-only-the-alarm-name-from-alarm-events-on-report/106948/1 "2025-06-03T11:12:27Z")

</div>

Hello, I am creating a daily alarm report using some modified code from the vision-alarm-analysis-template project from the exchange. It is working well, but am trying to find a way to only display the alarm name in the report instead of the complete displaypath text from the alarm\_events table.

For example, the report prints out for a.source:  
prov:Project\_16016:/tag:Main Line/S5/Faults/FaultBits\_94:/alm:S5 Press Faulted \<FaultBits[94].1\>

and I would like to instead only display only what is after alm:  
S5 Press Faulted \<FaultBits[94].1\>

Current working SQL code in data source:  
SELECT  
TOP 10  
a.source,  
(SUM(DATEDIFF(SECOND, a.eventtime, COALESCE(c.eventtime, CURRENT\_TIMESTAMP))))/60 duration  
FROM  
alarm\_events a  
LEFT JOIN alarm\_events c ON c.eventid = a.eventid AND c.eventtype = 1  
WHERE  
a.eventtime  
BETWEEN ? AND ?  
AND a.eventtype = 0  
AND a.eventflags != 1  
AND a.priority \> 2  
GROUP BY  
a.source  
ORDER BY  
duration DESC, a.source ASC

Thanks for any help!