Query to find all the inactive project admins in jira.

[Bhargav Tedla]

Query to find inactive admins of all the projects in jira.

[Hemanth Kumar]

#Project where project lead is not assigned
SELECT * FROM project WHERE lead NOT IN (SELECT user_name FROM cwd_user WHERE active = 1);

#Project where project lead is inactive
SELECT * FROM project WHERE lead IN (SELECT user_name FROM cwd_user WHERE active = 0);

[Grigory Salnikov]

Hi @Bhargav Tedla  and welcome to our Community!

As an option you can try the following marketplace app:

Manage Inactive Users For Jira

I haven't tried it myself, but it seems promising.

Hope it helps.

[Bhargav Tedla]

@Grigory Salnikov Thanks for your response. But it would be helpful if there is an SQL query for this. Currently am using the below query for getting project admins from all projects. i need to get only the admins who are inactive

select prjra.roletypeparameter PROJADMINS, prj.pname PROJNAME, prj.pkey PROJKEY
from PROJECTROLEACTOR prjra, PROJECT prj, PROJECTROLE prjr
where prjra.pid = prj.id
  and prjra.projectroleid = prjr.id
  and prjr.name = 'Administrators'
order by prj.pname