DX NetOps

In CA Spectrum where we can see the alarms and events in MySQL database?

You will find those information in the reporting database. Please take a look at the DB Schema:

Report Manager DB Schema - CA Spectrum - 10.1 to 10.1.2 - CA Technologies Documentation 

Report Manager DB Schema - CA Spectrum - 10.2 to 10.2.2 - CA Technologies Documentation 

Thanks,

Silvio

Spectrum events are stored in DDMDB

Hi, bith answers are correct.

Spectrum stores the received Events in the Archive-Manager, the DDMDB. This DB is excluselively used by the Spectroserver-Processes. You could try to access it but there is no support to do so.

In older docs I had read that it is forbidden to access it. The DB-Scheme is simple but not public.

After some minutes, or 1 hour, the events are forwarded or fetched by the Report-Manager-Database and stored there. This is the right place to access these events and alarms if You would like to do it by accessing a Database.

Keep in mind, that this is the best choice to report the alarms in daily, weekly or monthly reports but not for realtime-reports because the events move into the Reporting-Manager-Database after some minutes and not just in time.

Other options to get current events and alarms could be one of the provided APIs, the REST-API to get Alarms is a good choice.

I hope to help to make the right decision.

Hello Erich

Please allow me to clarify - you are correct that the Events are first stored in DDM / Archive manager on the SpectroSERVER. But it is not forbidden to access it. In fact if you are investigating an issue there are some recommended MySQL queries to run by logging into DDM MySQL. Please see the following link:

DDM Database Queries - CA Spectrum - 10.1 to 10.1.2 - CA Technologies Documentation 

Hope that helps. 

~JayV.