Some alarm properties not in the offload database

Solved765 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

3
2.03K 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.
You are viewing 1 out of 2 answers, click here to view all answers.