Layton ServiceDesk - Workflows - Bulk Change Email Domain
From Layton Support
(Difference between revisions)
(Major addition) |
(Major addition) |
||
Line 13: | Line 13: | ||
#Back up your database. It would be wise to also test this on a copy of your database before doing this on live. | #Back up your database. It would be wise to also test this on a copy of your database before doing this on live. | ||
#'''[http://client.laytontechnology.com/wp-content/themes/layton-admin/Update/bntlsd201/lsd_bulk_change_email_domain.zip Download the package of SQL scripts]'''. | #'''[http://client.laytontechnology.com/wp-content/themes/layton-admin/Update/bntlsd201/lsd_bulk_change_email_domain.zip Download the package of SQL scripts]'''. | ||
− | # | + | #In Management Studio, open ''LSD Bulk Change Email Domain 01 Create Stored Procedures.sql'' and execute it. |
− | + | #Open ''LSD Bulk Change Email Domain 02 Execute Stored Procedure Analyst.sql'': | |
− | #Execute the | + | ##Execute the query. |
+ | ##The top results pane will display the contents of the Analysts table. The lower pane will list just the domains present in the table, without the ''@'' symbol, for reference. | ||
+ | ##Click the domain to be changed from the lower list of domains and copy it with Ctrl-C. | ||
+ | ##Replace the string ''ENTEROLDDOMAIN'' with the copied domain. Note: Do not enter the ''@'' symbol. | ||
+ | ##Replace the string ''ENTERNEWDOMAIN'' with the new domain, without the ''@'' symbol. | ||
+ | ##Execute again to change the domain. The two lists will be presented again, for checking the results. | ||
+ | #Open ''LSD Bulk Change Email Domain 03 Execute Stored Procedure End User.sql'': | ||
##Execute the query. | ##Execute the query. | ||
##The top results pane will display the contents of the End User table. The lower pane will list just the domains present in the table, without the ''@'' symbol, for reference. | ##The top results pane will display the contents of the End User table. The lower pane will list just the domains present in the table, without the ''@'' symbol, for reference. | ||
− | ## | + | ##Click the domain to be changed from the lower list of domains and copy it with Ctrl-C. |
##Replace the string ''ENTEROLDDOMAIN'' with the copied domain. Note: Do not enter the ''@'' symbol. | ##Replace the string ''ENTEROLDDOMAIN'' with the copied domain. Note: Do not enter the ''@'' symbol. | ||
##Replace the string ''ENTERNEWDOMAIN'' with the new domain, without the ''@'' symbol. | ##Replace the string ''ENTERNEWDOMAIN'' with the new domain, without the ''@'' symbol. | ||
##Execute again to change the domain. The two lists will be presented again, for checking the results. | ##Execute again to change the domain. The two lists will be presented again, for checking the results. |
Revision as of 05:12, 28 September 2017
Contents |
Overview
If the domain for user email addresses needs to be changed, e.g., due to a company acquisition, importing End Users or Analysts will cause duplicates, because the email addresses are different. This script will change the domain without altering the name in front of the @ symbol. It is recommended that you test this operation on a test database prior to committing to live.
This procedure applies to both Analysts and End Users. There are a total of three scripts:
- LSD Bulk Change Email Domain 01 Create Stored Procedures.sql: Creates two Stored Procedures for updating the Analyst and End User tables
- LSD Bulk Change Email Domain 02 Execute Stored Procedure Analyst.sql: Executes the Stored Procedure for Analysts
- LSD Bulk Change Email Domain 03 Execute Stored Procedure End User.sql: Executes the Stored Procedure for End Users.
Procedure
- Back up your database. It would be wise to also test this on a copy of your database before doing this on live.
- Download the package of SQL scripts.
- In Management Studio, open LSD Bulk Change Email Domain 01 Create Stored Procedures.sql and execute it.
- Open LSD Bulk Change Email Domain 02 Execute Stored Procedure Analyst.sql:
- Execute the query.
- The top results pane will display the contents of the Analysts table. The lower pane will list just the domains present in the table, without the @ symbol, for reference.
- Click the domain to be changed from the lower list of domains and copy it with Ctrl-C.
- Replace the string ENTEROLDDOMAIN with the copied domain. Note: Do not enter the @ symbol.
- Replace the string ENTERNEWDOMAIN with the new domain, without the @ symbol.
- Execute again to change the domain. The two lists will be presented again, for checking the results.
- Open LSD Bulk Change Email Domain 03 Execute Stored Procedure End User.sql:
- Execute the query.
- The top results pane will display the contents of the End User table. The lower pane will list just the domains present in the table, without the @ symbol, for reference.
- Click the domain to be changed from the lower list of domains and copy it with Ctrl-C.
- Replace the string ENTEROLDDOMAIN with the copied domain. Note: Do not enter the @ symbol.
- Replace the string ENTERNEWDOMAIN with the new domain, without the @ symbol.
- Execute again to change the domain. The two lists will be presented again, for checking the results.