How to automate JIRA display name change for 500+ users?

[Greg Warner]

Hi,

I have a need to change approximately 500+ users' display name from:

Firstname Lastname

to

LASTNAME, Firstname

Is there a supported, automatable way to do this? I haven't seen anything in the API to provide this. My only option currently is to do for example:

{code}

select id from propertyentry where ENTITY_NAME='OSUser' and ENTITY_ID=(select id from userbase where username='username-to-change') and PROPERTY_KEY='fullName'

{code}

which returns a value of say, 11267

then to get the display name

{code}
select CAST(propertyvalue as varchar) from propertystring where id = '11267'
{code}

which I will then execute an UPDATE statement on it.

Surely there is a better way to do this.

Thanks
- Greg

[Renjith Pillai]

How about using Jira commandline with option updateUser?

https://plugins.atlassian.com/plugins/org.swift.jira.cli

[Bob Swift]

And specifically runFromSql to make it simple to do the updateUser action for all 500.