Query to fetch the users based on per project

[Krishna Chaitanya]

Hi Team,

Need a sql query which can fetch the projects and the list of jira users who are accessing it.

Thanks,

Krishna

[Shannon S]

Hi Krishna,

This article will show you how to list all users assigned to roles for a project, perhaps this will help you?

• How to get a list of users assigned to project roles for your project

Just for clarification, however, you asked for a list of jira users "who are accessing it". Can you let us know what you mean by that exactly?

Shannon