Layton ServiceDesk - Workflows - Bulk Change Email Domain
From Layton Support
(Difference between revisions)
(Major addition) |
m (Minor formatting changes) |
||
(One intermediate revision by one user not shown) | |||
Line 6: | Line 6: | ||
This procedure applies to both Analysts and End Users. There are a total of three scripts: | 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 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 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. | + | *''LSD Bulk Change Email Domain 03 Execute Stored Procedure End User.sql'': Executes the Stored Procedure for End Users. |
=Procedure= | =Procedure= | ||
− | #Back up your database. It would be wise to | + | #Back up your database. It would be wise to 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. | #In Management Studio, open ''LSD Bulk Change Email Domain 01 Create Stored Procedures.sql'' and execute it. |
Latest revision as of 05:13, 28 September 2017
Contents |
[edit] 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.
[edit] Procedure
- Back up your database. It would be wise to 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.