Clear all fields in Configure Default Send Email Action page

10/24/2018 8:37 PM

10/24/2018 8:37 PM

This article provides a workaround to delete all fields in 'Configure Default Send Email Action' page.
 

Network Performance Monitor

Some users will have SMTP Servers set in Web Settings -> MANAGE SMTP Servers Page.

• But this alone does not mean its set as a default in the Orion the environment.
• Users have to set an SMTP Server to DEFAULT with the 'Make Default' Button.
• 

Once done they will show in the WebSettings Tables, otherwise, no SMTP records will exists in the WebSettings Table.
 

1. Create a backup of your Orion database.
2. Go to Start > SolarWinds Orion > Advanced Features > Database Manager.
3. Click Add Server (Add Default Server).
4. Right-click on SolarWindsOrion Database.
5. Choose New Query.
6. Copy and Paste the following query:

   • SELECT TOP 1000 * FROM [dbo].[WebSettings]
     where settingname like '%defaultEmail%'

7. Click Execute Query and review and note the settings here.
8. Delete the values from the SettingValue column.

   • DELETE FROM [dbo].[WebSettings]
     where [SettingName] like '%defaultEmail%'

 

• Values here should NOT simply be edited to blank, we have to delete whole records referencing default email.
  • The whole settings need to be removed due to HA feature.
  • If there are partial or blank Values its will break HA, because HA is expecting no records or existing values in records, so delete statement is required here over UPDATE Statement to blank the SMTP Server out.
  • Due to HA not expecting empty (which is not possible to do without direct delete in SQL.
• Defaults should now be removed.