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.
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.
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.