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 votes
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
Community showcase
Published Feb 13, 2019 in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

599 views 0 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