I would like to be able to identify all of the triggers for a given action. We have accumulated redundant actions, and would like to merge them. Also, we would like to be able to make a list of triggers for a specific e-mail action (the one that e-mails the paging system). Is there a query that can be done that will relate the action name with monitors and attributes that can invoke the action?
Please download the attached AlertsQuery.txt from this post and follow the below steps for getting the list of Alerts configured in Applications Manager.
Login as default 'admin' user in Applications Manager webclient and go to the Support tab.Click on DB Status link near the 'JVM Memory Information' table in the Support tab and use the Query tool for executing the queries mentioned in the attached AlertsQuery.txt file.