Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Angela Morehouse]

I need to update our server name in the Workflow Email setup window. Has anyone done this in mass via SQL or other option? I have 80+ DBs and am looking for a quicker option than one company at a time, if one exists. 

——————————
Angela Morehouse
CC Industries
Chicago IL
——————————

[Dexterity Developer]

I don’t see any issue updating Server name from back end.
Will Server Name be same for all 80+ databases?
You can have SQL script with cursor which will read database ID from SY01500
and by using fully qualified references can update the workflow table (WF00100) for Server Name (SERVERID) field.
You just need to make sure that your server name must be in correct format as required by front end of workflow setup window.

Typically this is in a format similar to smtp.<your_company>.com. For help with this, consult your mail administrator.

——————————
dexteritydeveloper
dexteritydeveloper@gmail.com
https://keptonworking.blogspot.com/
——————————
——————————————-

[Angela Morehouse]

Thank you for your reply. This is exactly what I needed. I appreciate it!

——————————
Angela Morehouse
CC Industries
Chicago IL
——————————
——————————————-

[Dave Magalen]

You can probably SQL script it out by editing WF00100.  That should hold the SMTP info.  See the link below for more tables in Workflows to edit or grab for reporting.  I usually double check this in test by changing it in the GUI and looking to make sure that is the table that changed.  Then do the opposite to make sure and test to see if anything else is changed when using the GUI.

https://community.dynamics.com/gp/b/dynamicsgp/posts/workflow-2-0-tables-what-each-one-does-and-what-information-you-can-get-from-them-for-reporting-purposes

——————————
Dave Magalen
dmagalen@auroraplastics.com
IT Manager – Aurora Plastics
Streetsboro OH
——————————
——————————————-

[John Arnold]

Hi Angela,

While you are updating everything, I recommend making a DNS entry to represent your server.  I have the DNS entry of GP in our system that points to our actual GP server.  Anywhere I need to refer to the server, I use GP instead of the real server name.  It has made upgrading MUCH easier.  I would say that the DNS entry works in about 99% of the places I’ve used it, so please test it in the workflow in one of your companies first.

Using the DNS entry makes upgrading MUCH easier.  When we were ready to switch to our new server, I updated DNS and pointed GP to the new server.  Then I either rebooted each computer or ran   IPCONFIG /flushdns  the command prompt so the updated DNS machine is now in use.  

Using the GP DNS entry has made so many things much easier.  For example, I didn’t have to edit any of my Excel Refreshable reports with over 70 database connections to point to the new server.

I hope this helps!

——————————
John Arnold
Senior Software Engineer
US Digital
Vancouver WA
——————————
——————————————-