list of project managers

Question

I ask for help in preparing the sql script.
I'm trying to get a list of project managers by MS SQL, who do not have Administrator permission in a project.

Jira version 6.3.10

Marat_lcjzvw · Answer

Hi
Sorry maybe I wasn't clear. 
This script return list of lead, but not the permission in project.
How to return name lead and his permission in project ??

miikhy · Answer

Hi,

The following query might be doing the trick for you:

SELECT p.pname AS "Project Name", p.lead as "Project Lead Username", u.display_name AS "Project Lead" FROM "project" p LEFT JOIN cwd_user u ON p.lead = u.lower_user_name;

It's designed for PgSQL but could be easily translated to any DB :)

Cheers