Version 1

    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