Update Mentioned Usernames in Comments/Content in JIRA & Confluence

[Trevor Hunt]

We recently installed localized instances of both Confluence and Jira. While doing so, we converted over to Active Directory for our user directory and user management. Afterwards, I ran all of the user conversion scripts to update user names in Confluence and manually changed user names in JIRA.

Overall, evertyhing went quite smoothly, but I would like to take it a step further and run a query of some sort to update old usernames showing in mentions throughout content and comments to reflect the updated user names as well.

Can anyone point me to a script or something that might assist me in doing this?

Regards,

Trevor

[Trevor Hunt · Accepted solution]

We'll go with no answer.

[Siri Vias Khalsa]

All of the comments are stored in the database, Id bet your best option would be to parse through the text in the database and update it there. Of course you would want to test this in a non production environment and backup before you make any changes.

[Trevor Hunt]

Another bump... I'd really like to resolve this.

[Trevor Hunt]

Can someone with Atlassian confirm whether or not this can be accomplished? And if so, provide pointers on doing it?

[Trevor Hunt]

Anyone? Any atlassians out there with some input... or is this a fairly complicated undertaking?

[Trevor Hunt]

Just bumping this so it doesn't get lost in Davy Jones' locker.