Where are Component info & Key point stored in SQL

Solved1.41K viewsalarm properties MySQL
4
0 Comments

In Cassandra there are dedicated fields for Component info & Key point in the alarm table, but in SQL these fields are not present.

Where are these values saved there? Or are these always read from the information template at runtime?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 10th July 2023

1 Answer

3
1.53K 0 Comments

These fields are not stored in MySQL. They are retrieved at runtime from the information template when an alarm is generated or Requested. SLElement will do this when an alarm is created or an open alarm is configured during element startup. SLNet will mostly handle the cases involving historic data.

In Cassandra these are stored in the database under the CI 'componentinfo' and kp 'Key point'.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 10th July 2023