Finding not used project roles

As within a time JIRA project roles get bigger than Admin expectations, I'm looking for a way to detect those project roles which are not used.

I see here two ways:

1. SQL - magic for me

2. rest api - /rest/api/2/project/{projKey}/role and then went trough each role to collect empty one


Did someone have had similar optimization task?

2 answers

1 accepted

0 votes
Answer accepted

I find SQL for that purpose. It can be easily modified to find groups also.


SELECT p.pname, pr.NAME, pra.roletype, u.display_name
FROM projectroleactor pra
INNER JOIN projectrole pr ON pr.ID = pra.PROJECTROLEID
INNER JOIN project p ON p.ID = pra.PID
INNER JOIN app_user au ON au.lower_user_name = pra.ROLETYPEPARAMETER
INNER JOIN cwd_user u ON u.user_name = au.user_key
order by p.pname,, u.display_name


Hi Marcin,


If the list is not very long, this can be done manually via the Project Role Browser (/secure/project/ViewProjectRoles.jspa) and then clicking on 'View Usage' for each Project Role.



Daniel, you are right. That's another option. My case is focused on large instance so i will stay with rest.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 14, 2019 in Jira

Updates to give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

643 views 1 15
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