report on User project access

Question

I need generate psql report contain the following information:

Project Name

User Name

Project Category

Project Lead

Project Permission Scheme

The report needs to ensure that it also identifies any additional users who have been added to a project, but not part of the permission group set up for that project.

Kindly help me with a PGSQL query to generate the same report.

naagraaju · Answer

@Brant Schroeder  Thanks a lot. This is really helpful.

Brant Schroeder · Answer

@naagraaju

I believe this has some of what you are looking for.  https://confluence.atlassian.com/jirakb/retrieve-a-list-of-users-assigned-to-project-roles-in-jira-server-705954232.html

you could add p.lead to get project lead out of the project table.

You can combine that with this query to get category.  https://confluence.atlassian.com/jirakb/how-to-list-all-projects-in-a-specific-project-category-781194603.html

I am not sure what table has the permission scheme.