How to view and list which alarm that sends out email from Solarwinds?

I use a custom SWQL query for getting the relevant info on alert actions, you could filter it a few ways to narrow in on things if you like.

--Alert Configuration and Actions Report
select
ac.name as [Alert Name]
,'/Orion/Alerts/Default.aspx' as [_linkfor_Alert Name]
,case when ac.Enabled=1 then '/Orion/images/StatusIcons/Small-Up.gif'
when ac.Enabled=1 then '/Orion/images/StatusIcons/Small-Up.gif'
end as [_iconfor_Alert Name]
,ac.Description
,ac.Frequency
,case when ac.frequency < 60 then '/Orion/images/StatusIcons/Small-Critical.gif'
else '/Orion/images/StatusIcons/Small-Up.gif'
end as [_iconfor_Frequency]
,CASE
WHEN ac.Severity = 2 then 'Critical'
WHEN ac.Severity = 3 then 'Serious'
WHEN ac.Severity = 1 then 'Warning'
WHEN ac.Severity = 0 then 'Informational'
WHEN ac.Severity = 5 then 'Notice'
END AS [Severity]
,CASE
WHEN ac.Severity = 2 THEN '/Orion/images/ActiveAlerts/Critical.png'
WHEN ac.Severity = 3 THEN '/Orion/images/ActiveAlerts/Serious.png'
WHEN ac.Severity = 1 THEN '/Orion/images/ActiveAlerts/Warning.png'
WHEN ac.Severity = 0 THEN '/Orion/images/ActiveAlerts/InformationalAlert.png'
WHEN ac.Severity = 5 THEN '/Orion/images/ActiveAlerts/Notice.png'
END AS [_iconfor_Severity]
,ac.AlertMessage
--,ac.trigger
--,ac.reset
,aa.CategoryType
,a.actiontypeid
,ap.propertyname
,ap.propertyvalue

from orion.actionsassignments aa
join orion.alertconfigurations ac on aa.parentid=ac.alertid
join orion.actions a on a.actionid=aa.actionid
join orion.actionsproperties ap on ap.actionid=a.actionid

where ac.enabled=1
and ap.PropertyName not in ('EscalationLevel','executionIfAknowledge','executionRepeatTimeSpan','MessageContentType','Priority','SmtpServerID' )
and ap.PropertyValue is not null and ap.PropertyValue not like ''
--and (propertyname like 'EmailTo' or propertyname like 'EmailCC' or propertyname like 'EmailBCC')
--and (ac.name like '%${SEARCH_STRING}%' or ap.propertyvalue like '%${SEARCH_STRING}%' )`

order by ac.Name, aa.Categorytype desc, a.ActionTypeID, ap.PropertyName

mesverrumThat is an excellent query! Thanks

mesverrumThat is an excellent query! Thanks