This query will return the entire set of alerts that are defined in DPA, along with each threshold and the contacts assigned to the threshold. If a group is used as a contact, all contacts in those groups will be shown too. Webhooks and SNMP traps destinations are also shown. It's a great report to help make sure all alerts have the correct contacts tied to them.
To run this report, download the attached script and run against the DPA repository database. The output will look similar to this:
