For the SRM reporting database what is the query to see the trouble ticket id with mysql

Document ID : KB000124480
Last Modified Date : 15/01/2019
Show Technical Document Details
Introduction:
Tech doc to confirm the query that can used directly on mysql database to see the trouble ticket id for alarms
 
Question:
For the SRM reporting database what is the query to see the trouble ticket id with mysql
 
Answer:
  1. The trouble ticket id can be viewed in the alarminfo table:
 
Select * from alarm info;
  1. Further details are available around trouble ticket:
https://docops.ca.com/ca-spectrum/10-3-0/en/managing-client-applications/report-manager/report-manager-db-schema/reporting-database/#id-'reporting'Database-alarminfo
 
FieldTypeNullKeyDefaultComment
set_troubleticket_user_keyint(10) unsignedYESMUL Trouble ticket user key for the specific alarm.
set_troubleticket_timedatetimeYES  Time of the trouble ticket assigned.
set_troubleticket_idchar(255)YES  Trouble ticket ID of the alarm.