How to find an email addresses assigned to an Orion alert

In scenario where customer would like to find an email address assigned to an alert created in Orion Platform, they can follow the recommended steps that can be found on the said resolution.

1. Login to your main Orion Server
2. Open Orion Database Manager.
3. Click Add default server and expand your SolarWinds database.
4. Double-click on the table: Actions
5. Click Execute query.
6. Scroll to the right to find the 'Description' Column
7.  The Description column contains the to, from, and subject lines for email actions.
   

For Orion that is on Web Based Alerting

Tables from Old Alerting and Web Based Alerting

1. Using Orion Database Manager, use ActionProperties table to show the email addresses assigned to trigger/reset email action.

Each record has ActionID which can be mapped to ActionsAssignments table.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.
 

2. Use the ActionID value to search for the ParentID in ActionsAssignments table.

The ParentID value can be mapped to AlertConfigurations table, this will help identify which alert has this email address on its trigger/reset email action.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

3. Below is the result of finding the name of the alert based on the ParentID (which is AlertID on AlertConfigurations table)

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.