Hi @Thangaselvi Kasamuthu,
You can use ad-hoc reports to fetch this report.
Login to Jasper -> Create -> Ad-hoc views -> Select "Alarm Domain" -> Choose Data -> From Source, navigate fields in "alarm" -> select the fields ( example: Model Name, Network Address, Alarm Title, Created on, Cleared on) and from "Alarm Details" -> select "Trouble Ticket ID") -> Save the ad-hoc view.
- Once you run it, alarms and ticket numbers will be populated within one table.
- You can create filters on fields "Created on/Cleared on" within the ad-hoc view to run it for specific time
Hope it helps.
Original Message:
Sent: Apr 30, 2025 12:10 PM
From: Thangaselvi Kasamuthu
Subject: Trouble Ticket ID column in CABI
Hi All,
I am trying to fetch the alarm log report from CABI , but we need a alarm info and trouble ticket info side by side . Because in CABI we need to drill down into each alarm to see ticket ID which is not possible. Any thoughts ?