Way to filter based on roles

[Leena Siddamshetty]

Hello All,

I am looking for a way to filter users based on a particular role. Like I want to find out how many users are added in Scrum master role all over Jira instance and not specific to any single project. Can this be achieved?

[Pramodh M · Accepted solution]

Hi @Leena Siddamshetty

You could use marketplace add-ons to get these details

https://marketplace.atlassian.com/apps/1211389/project-roles?tab=overview&hosting=cloud

Let me know if you have any queries

Thanks,
Pramodh

[Pramodh M]

FYI - Data Center Add-ons here

https://marketplace.atlassian.com/apps/1211389/project-roles?tab=overview&hosting=datacenter

[Leena Siddamshetty]

thanks @Pramodh M but this add on is also project specific I guess. I am looking for data from complete Jira instance as how many users are in scrum master role on Jira instance. Can that be achieved? Any JQL that can give such data?

[Pramodh M]

Hi @Leena Siddamshetty 

Here's a KB Article, it needs command to be run in db

https://confluence.atlassian.com/jirakb/retrieve-a-list-of-users-assigned-to-project-roles-in-jira-server-705954232.html

Let me know if you have any queries

Thanks

[Leena Siddamshetty]

Thank You!! that helps!!