Some alarm properties not in the offload database

Solved773 viewsalarm properties Last change last modified offload Offload MySQL
3
0 Comments

Hi Dojo,

I couldn't find some alarm properties in the offload tables, such as "Last Change" and "Last Modified".

Is there a way of finding this in the offloaded data?

Thanks

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

2 Answers

2
5.44K 0 Comments

Hi Elvio,

The fields you mention ("Last Modified" and "Last Change") are standard fields of alarm events within DataMiner and not part of the custom alarm properties.

These fields are indeed not offloaded to a central database (see the full list of offloaded fields for the alarm table)

The columns "Last Modified" and "Last Change" in the alarm console are related to the AlarmSquashing soft-launch feature. They don't exist at the raw alarm level.

You should however be able to extract the same information from the "toa" and "type" columns that do get offloaded:

  • "toa" (time of arrival) indicates the time when the alarm event was created in DataMiner
  • "type" contains a numerical value which maps to values like "acknowledged", "properties changed", ...
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023
You are viewing 1 out of 2 answers, click here to view all answers.