Some alarm properties not in the offload database

Solved983 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.94K 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
3
2.46K 1 Comment

Hi Elvio

I’m not very familiar with the offloading of alarm properties to a central database, so I’m not able to give you a straight answer.
What I understand from your question is that some alarm properties are being offloaded and some aren’t, correct?

What might help is to compare properties that are offloaded vs properties that are not offloaded.

I’m mainly thinking about:

  • right-click an alarm > properties > general vs custom (> custom props, double click to have more options)
  • C:/Skyline Dataminer/PropertyConfiguration.xml
    find those properties of type alarm and compare the arguments (e.g. filterEnabled, visibleInSurveyor, readOnly,…)
  • Maybe you know/remember when the properties were created? Or how they were created?

Perhaps this way you can find a link/pattern which could identify why a property isn’t offloaded.

Elvio Mendes Posted new comment 17th March 2023
Elvio Mendes commented

Hi Robin
On this case, I believe it is an original dataminer property instead of a manually created property
“Last modified” column in alarm console displays the time it was last modified and, last change displays the type of change e.g. acknowledged, properties change….. which are handled by dataminer.
Are these properties expected to be exported?
Regarding the manually created properties I can confirm these are in the properties table.
For this particular use case, I am looking at creating reports out of the offload DB to measure the time to acknowledge alarms by the users.