Historical alarms report

Products

• CA Spectrum

Issue/Introduction

The customer needs to export the alarm history from spectrum, but we can't find any interface or service to extract closed alarms. I know those alarms are stored in the Archive. Is there any way to do that? 

Environment

Release : 10.x, 21.2, 22.2

Component : Spectrum Alarm & Event Management

Resolution

The alarm events are also stored in the Archive Manager's DDMdb database. But any event is saved as a packed octetString in the DDMdb. The whole var data is saved in binary and it is not in a human-readable format.

There are only two ways to retrieve the historical alarms:
a) From the OneClick Console, in the Events TAB, 0x10701-0x10709 event codes.
b) From the CABI JasperReports, which pulls the data from the reporting database.

https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=42f2b593-71ba-4955-8833-d55132b7b460&CommunityKey=671164c3-e575-4b08-96ab-edc2e1ceed13&tab=digestviewer#bm42f2b593-71ba-4955-8833-d55132b7b460