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

Thanks people for your assistance in this matter.

--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 

mesverrum, when I execute the query you've suggested inside the Database manager, it throws error:

Msg 208, Level 16, State 1, Line 2
Invalid object name 'orion.actionsassignments'.

It's a SWQL query, I generally use it as part of a custom query widget or custom table data source.

It's a SWQL query, I generally use it as part of a custom query widget or custom table data source.