How to change Project lead on 30 or more projects with JQL /SQL query

We have 500 user licenses and right now very few are left .That being said, We deactivate terminated users in Jira to reclaim the license back.

When I try to deactivate that user it throws a message saying that "Cannot Deactivate user because they are curently the Project lead on these projects : it could be anywhere from 5 to 30 Projects ( open and closed ones) "

So far before the Previous jira admins were changing Project lead on all these projects ( open/closed) manually. I dont want to get into that mess as it doesnot make sense to go in each project and change the lead. Is there any other effiecient way of doing this? may be some JQL query that I could use or some SQL query that I could give to my SQL DBA to run against the db

Also When I try to search for the Projects in Jira for this user, it only returns all Issues for her that were assigned to her or that she reported and not the Projects that she was a lead on.

 

Sorry for long post though.. 

1 answer

0 vote
Thomas Schlegel Community Champion Jun 06, 2017

Hi Leena,

I also have this problem frequently and did not find another way in the last ten years than go to the project and change the project lead or component lead.

 

 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

643 views 6 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you