Hi Team,
[Product]
DX NetOps Spectrum
[Questions]
Please tell me about the records in the alarminfo table on the reporting mysql database running on the OC server.
A customer has contacted us stating that the number of alarms confirmed by applying select to the alarminfo table does not match the number of events displayed on the OneClick Java GUI.
Please confirm what information on OneClick the records stored in the alarminfo table match.
Also, could you please let us know if there is a manual or Knowledge Base that explains the operation when an alarm is stored in the Reporting database?
For reference, we have provided a sample of the SQL statement executed by the customer.
* Displaying a list of alarms with severity: Critical or severity: Major that occurred from 2024/1/1 to 2024/2/1
-----
select alarminfo.set_time as Time,
alarmcondition.condition_name as Severity,
devicemodel.model_name as Hostname,
devicemodel.IP as IPAddress,
case alarminfo.cause
when 65540 then 'Communication not possible: Possible failure of upper level equipment'
else alarmtitle.title
end as AlarmTitle,
concat('0x',lpad(hex(alarminfo.cause), 8, 0)) as CauseID,
group_concat(globalcollection.gc_name) as GC
from ((((( alarminfo
inner join alarmtitle on alarminfo.alarm_title_id = alarmtitle.alarm_title_id )
inner join alarmcondition on alarminfo.condition_id = alarmcondition.condition_id )
inner join devicemodel on alarminfo.model_key = devicemodel.model_key )
inner join gcmodel on alarminfo.model_key = gcmodel.model_key )
inner join globalcollection on gcmodel.gc_rec_ID = globalcollection.gc_rec_ID )
where ( set_time >= {ts '2024-01-01 00:00:00'} and set_time < {ts '2024-02-01 00:00:00'} )
and ( alarmcondition.condition_name = 'Critical' or alarmcondition.condition_name = 'Major')
group by alarminfo.alarm_id;
-----
Thanks,