Hello! Today I was working with SW's support on how to locate all alerts using a incorrect email.
Case # - 00567525 Cached alert emails - How-To remove
After discussing the problem with he engineer. Seems there is a Actions Table on the Orion DB, where you can query the name of the incorrect email address.
After locating all of the items under the title column. You can then go back into Orion Web console/UI under alert action manager and locate and correct these.
Wish SW's would enhance this and make it easier for customers to do this under the alert manager/alert action manager and also on the web reports.
Query:
SELECT TOP 1000 * FROM [dbo].[Actions]
WHERE Description LIKE '%Email Name Here%'