Alarms Export to Excel

Moises,

Trying to make sure we understand your question, are you trying to capture the configuration or the actual historical alarms? 

If you log alarms to a database its possible to retrieve them from there, you could based on your current filter query in the 'same' way.

But as Scott points out some more context is needed, but in general there is no available "export list to excel" feature in the alarm window.

There are some better or worse ways to resolve your issue, if in fact it is this what your end goal is, i.e. getting the content in to a csv file etc.

But the most out of the box alternative is to save your alarms to a database using Alarm DB Logger utility. And then use Excel to point to the WWALMDB to retrieve the data, based on the current filter (like start and stop time).

If you were using Application Server, or InTouch 2023 R2 you could log all alarms to Historian where there are even more and better alternatives.

Please let us know your thoughts and we might be able to assist you better.

Hi Scott and Richard Köhlerstrand thanks very much for your feedback, according to the client they are trying to download the total alarms configuration file in excel possibly, and the actual historical alarms too. The reason is that, as part of industry standard for alarms management, they need to perform a rationalization exercise for all configured alarms and perform daily bad actor analysis. For these exercises to be possible we need to extract all configured alarms and be able to also export daily alarm logs to an excel worksheet for analysis. 

Thanks for clarifying.

As mentioned, the best approach would be to set up logging to a database, this will allow for many ways of analyzing the alarms based on the customer need.

If you have AVEVA Historian in your setup it is fairly simple in the later versions, where integration with Historian is built in to the configuration and supported by the alarm components for historical retrieval.

And you could log the necessary context to make analysis easier (batch start and stop time, equipment state and so on).

But if Historian is not an option, you could also check out the Alarm DB Logger Manager utility, this will save all alarms (and events) to a database, where analysis can be made based on the data saved.

A third trick would be to save all alarms to a csv file using the Alarm printer utility.

But there is no built in option, to export data visible in the alarm component, that will export the content to a excel file.

As mentioned I have created some applications that keep track of the Query used in the alarm component, such as start and stop time, any filter etc. and the based on this, apply the same filter options as a Query against the alarm database, exporting data to a file for analysis.

Also it is possible to get data from a row in the alarm component, and there might be some additional ways using scripting, perhaps some one else has some idea, since there are some undocumented script commands available in the alarm component.

Hi Richard, I really appreciate your detailed feedback. Thanks very much