Query all alarm attributes within a galaxy

************ Alarm Enabled

SELECT g.tag_name + '.' + p.primitive_name AS name, p.gobject_id, p.package_id, p.mx_primitive_id

FROM dbo.gobject AS g INNER JOIN

                      dbo.primitive_instance AS p ON p.gobject_id = g.gobject_id AND p.execution_group = 19 INNER JOIN

                      dbo.primitive_definition AS pd ON p.primitive_definition_id = pd.primitive_definition_id AND pd.primitive_name <> '' INNER JOIN

                      dbo.package AS pkg ON p.gobject_id = pkg.gobject_id AND p.package_id = pkg.package_id AND pkg.package_id = g.checked_in_package_id

WHERE (g.is_template = 0) AND (g.namespace_id = 1)

I didn't make it past the "....for all attributes configured for alarming".   Sorry. :)

I believe the priority and message are stored in a manner that you would not be able to easily query.  Likely stored in a blob or bitmap.  There might be a way to build an application using the GR Access toolkit to do this.  Another way might be to at least get all the object.attribute names, then use that list to query a CSV file that is created from the Galaxy Dump where the priority and description/message are in plain text.

I didn't make it past the "....for all attributes configured for alarming".   Sorry. :)

I believe the priority and message are stored in a manner that you would not be able to easily query.  Likely stored in a blob or bitmap.  There might be a way to build an application using the GR Access toolkit to do this.  Another way might be to at least get all the object.attribute names, then use that list to query a CSV file that is created from the Galaxy Dump where the priority and description/message are in plain text.

Hi David,

I ended up "solving" it with a script that writes what I´m looking for to a file. It works but it needs to sit on every template and the instances deployed for the script to execute.

I hope someone from AVEVA picks up on this thread and appreciates the need for an export/import utility that solves this usecase.

Thanks David!

Thomas: 

This is a perfect example of something that you put an enhancement request in for.  You can work on this through your distributor.   

This way, it will be evaluated as part of the development cycle.  It's far from a guarantee it will be incorporated as there are typically a good amount of things that are , but typically DEV isn't combing the forums looking for enhancements, they look at the formal reequests.