Query all alarm attributes within a galaxy

Getting the alarm names and associated objects is pretty easy. 

Through sql, there's a view called internal_all_alarms_view that gives you the Object.Attribute.  IT does not give you the message and priority, though.  

doing

select gob.tag_name, iav.name from internal_all_alarms_view iav 

left outer join gobject gob on gob.object_id = iav.gobject_id

order by tag_name asc

...but that doesn't get you the priority nor the message.  Let me stew on it a bit. 

Getting the alarm names and associated objects is pretty easy. 

Through sql, there's a view called internal_all_alarms_view that gives you the Object.Attribute.  IT does not give you the message and priority, though.  

doing

select gob.tag_name, iav.name from internal_all_alarms_view iav 

left outer join gobject gob on gob.object_id = iav.gobject_id

order by tag_name asc

...but that doesn't get you the priority nor the message.  Let me stew on it a bit. 

Hi Phil,

This is where I gave up as well, I simply can´t find a way to get the message and priority out of the thing.