Need to remap userID in Sonarqube as Our user ldap directory changing(In crowd ) from one organization to other

Need to remap userID in Sonarqube as Our user ldap directory changing(In crowd ) from one organization to other. So for the same users who will be part of new organization we have to use the different new login IDs keeping all his comments, issues, security tokens etc. assigned to same user even after changing his log in ID.

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    6.7.5 SQ, Java version 8, Postgres DB

  • what are you trying to achieve
    Using 6.7.5 sonarqube version. Now that our user ldap directory changing from one organization to other. So for the same users we have use the different login ID keeping all his comments, issues, security tokens etc. assigned to same user even after changing his log in ID. Please suggest how to achieve this

  • what have you tried so far to achieve this
    Tried deactivating a user with old login and logged in with new ID, but losing all his comments and issues, tokens

  • tried updating user login in user table by using update query and setting new ID.
    Still same issue that user when he logs in with new ID his issues, comments etc showing his old ID and user lost control over comments he made earlier using old ID.
    Only the changes done newly are with him.

Hello!

The ability to update a login (via Web API only) came with SonarQube 7.6. Once you’ve upgraded (preferably to the 7.9 LTS), you can use POST api/users/update_login to update a user’s username.

Colin

Hello Thanks for your reply.

Can we update logins via database for 6.7.5 SQ, as we know what will be the login for the users. ?

As you said in 7.9 its possible to update login via api , when i update a users login , all his earlier data ( issues, comments, tokens etc ) will remain with him ?
because here our crowd directory itself changing to new organisation ldap. So users mail ID , login IDs are getting changed.

Regards
Jagadeesh