Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Global change to SMTP server setting

kempj18

How do I change the SMTP server for all Alerts? Where is it stored in the database?

jkemp

Find more posts tagged with

Accepted answers

All comments

Network_Guru

It's stored in the alerts table:

I don't have the exact table names in front of me, but it goes something like this:

Edit the SMTP name in the database directly by running a query similar to;

Update Alerts
Set SMTPServer=<new-name>
Where SMTPServer=<old-name>

using the Database Manager.

You can see the data & fields in the DB using the Orion DB Manager.

-=Cheers=-
NG

kempj18

I've looked at the Alerts table, and no column is listed with the word SMTP in it. I've also looked at the AlertActions table. Any other ideas?

Network_Guru

There is no column with SMTP in it.
The SMTP address is contained in each alert individually in the Target Addresses columns, right after the BCC field.

-=Cheers=-
NG