DX NetOps

Expand all | Collapse all

SRM Reporting Schema Alarm Status

  • 1.  SRM Reporting Schema Alarm Status

    Posted 10-10-2018 01:59 PM

    We have a developer working on his own reporting,  He would like to retrieve the data from the Alarm Status field (0x11f4f) and was wondering if that is collected and stored by Spectrum Report Manager (SRM).  If so, what field would it be?  I've looked over the schema doc and can't find it.  I know that we collect alarm changes, such as who and when an alarm is acknowledged.  Do we also collect the alarm status within SRM?


    We are currently running Spectrum 10.2.0, expecting to upgrade to 10.3 in a couple weeks.

  • 2.  Re: SRM Reporting Schema Alarm Status

    Broadcom Employee
    Posted 10-11-2018 02:46 PM

    I could not find the  AlarmAttrID.ALARM_STATUS Alarm Status (ID 0x11f4f)  in the reporting database schema.

    'reporting' Database - CA Spectrum - 10.2 to 10.2.3 - CA Technologies Documentation 


    But we do record the Status change as an event in the Historical database.




  • 3.  Re: SRM Reporting Schema Alarm Status

    Posted 10-11-2018 02:54 PM

    Thanks.  That confirms what I found with my searching.


    What I may do is to setup a REST subscription to the alarms and have that insert into my own table on the SRM system.  That way they can join it with whatever queries they do.