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

This widget could not be displayed.
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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

148 views 2 0
Join discussion

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