query to find email action associated with monitors
I have to track down each email action and see where it is used in the monitors. I was hoping you could find this association through a sql query. Can any one help me write such a query to run under support->db status tool to get a list of monitors and the email actions that are associated with their alarms?