WARNING!!! ACTIONS WITH SQL SCRIPTS SHOULD BE PERFORMED WITH GREAT CAUTION. IMPROPERLY EXECUTED SCRIPT CAN CAUSE SYSTEM CRASH. USE THIS MANUAL ONLY IF YOU HAVE A TECHNICAL BACKGROUND AND PREVIOUSLY WORKED WITH SQL SCRIPTS.

General description

These steps are the faster way to select the Users with the duplicates and remove them because these actions can be performed from the Superadmin account without the necessity to switch between Users' Creatio accounts

Extension removing duplication for a certain user.

These steps can be done instead of the p. 1 - 3 of the parent guide Problem with Extensions and Usernames duplicate

1. To check your CurrentContactId from the left main menu select ‘Contacts’ (Fig. 1)
   Fig. 1 Contacts selection

   

2. In the search field enter the name of the required Creatio contact (1) and press magnifying glass icon (2) (Fig. 2)
   Fig. 2 Using the search field

   

3. In the appeared result(s) click on the Name of the required contact. A contact card will be opened. In the address bar, you can find a CurrentContactId at the end of the line (Fig. 3) and copy it.
   Fig. 3 CurrentContactId location

   

   1. Ask this User to copy the following settings: “RingCentral URL“, “Client ID“, “Client Secret“ parameters.

4. Click on the ‘Gear’ icon in the upper right corner (Fig.4)
   Fig. 4 Location of the ‘Gear’ icon

   

5. Select ‘Open system designer’ (Fig. 5)
   Fig. 5 Open system designer option

   

6. Scroll down the page and click on the 'SQL query console' (Fig. 6)
   Fig. 6 SQL query console

   

7. In line 12 enter the following script delete from VvtSysAdminUnit where VvtContactId = '%CurrentContactId% Instead of the word CurrentContactId enter the CurrentContactId that you have copied in p. 3 and press the 'Execute’ button (Fig. 7)
   Fig. 7 Entering and executing the script

   

8. From this point, the User can perform actions from p. 4 of the parent guide Problem with Extensions and Usernames duplicate

9. Instead of p. 17 - 19 of the parent guide Problem with Extensions and Usernames duplicate the following actions can be performed.

10. This script allows to get all VvtContactId of the Users connected with certain extension with the Ring Central account. Repeat actions from p. 4 to p. 6 ‘. In line 12 enter the following script and select VvtContactId from select VvtContactId, VvtLogin from VvtSysAdminUnit where VvtLogin like '%Extensions%' Instead of word Extensions write the required extensions of the Contact and press the 'Execute’ button (Fig. 20)
    Fig. 20 Entering and executing the script

11. As a result, you will receive the VvtContactId (Fig. 21)
    Fig. 21 Receiving VvtContactId via the SQL script request
    

12. To remove the connection between that user and the Ring Central account:
    Step 1: Remove the previous script from the 12 line and replace it with the following one delete from VvtSysAdminUnit where VvtContactid = 'VvtContactId'
    Substep 1: To perform bulk removal use the following script delete from VvtSysAdminUnit where VvtContactid in ('VvtContactId','VvtContactId')
    Instead of VvtContactId write VvtContactId that you have received from p. 9 or p. 11 and press the 'Execute’ button.
    Step 2: Remove the previous script from the 12 line and replace it with the following one delete from ContactCommunication where VvtContactid = 'VvtContactId' Instead of VvtContactId write VvtContactId that you have received from p. 9 or p. 11 and press the 'Execute’ button.
    Substep 2: To perform bulk removal use the following script delete from ContactCommunication where VvtContactid in ('VvtContactId','VvtContactId')

13. From this point p. 20 - 22 from the parent guide Problem with Extensions and Usernames duplicate should be performed