/
Problem with Extensions and Usernames duplicate - Advanced option

Problem with Extensions and Usernames duplicate - Advanced option

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

    image-20240312-054446.png
  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

    image-20240312-094356.png

     

  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

 

 

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

  2. 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

 

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

 

  1. 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')

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

Related content

Problem with Extensions and Usernames duplicate
Problem with Extensions and Usernames duplicate
More like this
Creatio Importing
Creatio Importing
More like this
Document Importing
Document Importing
More like this
CallerID dropdown Feature configuration in Creatio (former 'Use My Number')
CallerID dropdown Feature configuration in Creatio (former 'Use My Number')
More like this
RingCentral Configuration
RingCentral Configuration
More like this
Adding Users in Velvetel
Adding Users in Velvetel
More like this