Here is a sample SQL query to list the Active Alerts using Email Actions with 'default' in them.
SELECT TOP 1000
ROW_NUMBER() OVER(ORDER BY Parentid ASC) AS Row
, ac.enabled as alerton
, a.enabled as actionon
, Parentid
, (select ac.name from AlertConfigurations as ac where aa.parentid = ac.alertid) as alertname
, aa.actionid
, (select a.description from Actions as a where aa.actionid = a.actionid) as actiondesc
, aa.ActionAssignmentid
FROM [dbo].[ActionsAssignments] as aa
inner join AlertConfigurations ac on aa.parentid = ac.alertid
inner join Actions a on aa.actionid = a.actionid
where a.description like '%default%' and ac.enabled = 1
Attached is a Report version you can import into Orion Web console 'Report Manager'
!sw+Active+%27Alert+Action+Email+Default%27+List.xml