Displaying only the alarm name from alarm_events on report

Ignition
1

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!