...
- Log into ECM Instance server (ECM Instance Edge1 in Bomgar).
- Open SQL Management Studio.
- Click ecm.cloud under Databases.
- Right click dbo.SystemSettings and choose Select Top 1000 Rows.
- Press CTRL+N for a new SQL Query page.
- Enter the query below and change the set value sections to their indicated changes. (i.e. Auth Token, Account SID, etc, then click Execute.
Begin transaction update [ecm.cloud].[dbo].[SystemSettings] set value ='Auth Token' where SystemSettingId ='F3CA754B-9B7B-493A-B622-00CDAE43445F' update [ecm.cloud].[dbo].[SystemSettings] set value ='Account SID' where SystemSettingId ='C73ABD0C-F803-4341-992D-2EE72FF2393F' update [ecm.cloud].[dbo].[SystemSettings] set value ='Phone Number' where SystemSettingId ='E249932E-F457-4F8B-A94E-5826BC46F065' Select * from SystemSettings where name like '%twilio%' Rollback Select * from SystemSettings where name like '%twilio%' |
|---|
- This initial query will show the differences in the changes comparing them with a before and after look, because of the Rollback clause.
- After review, change Rollback to Commit.
| Info |
|---|
Verify ALL CHANGES are correct before running the commit query. |
Begin transaction update [ecm.cloud].[dbo].[SystemSettings] set value ='Auth Token' where SystemSettingId ='F3CA754B-9B7B-493A-B622-00CDAE43445F' update [ecm.cloud].[dbo].[SystemSettings] set value ='Account SID' where SystemSettingId ='C73ABD0C-F803-4341-992D-2EE72FF2393F' update [ecm.cloud].[dbo].[SystemSettings] set value ='Phone Number' where SystemSettingId ='E249932E-F457-4F8B-A94E-5826BC46F065' Select * from SystemSettings where name like '%twilio%' Commit Select * from SystemSettings where name like '%twilio%' |
|---|