SQL: Amount of users with a certain role for every project

[Andreas Lorz]

Hi,

I want a list of projects and the amount of users in that project that have a certain role.

Is there a SQL query which i can use or is there an other way to retrieve that information from Jira (e.g. API)

Thanks in advance.

Andreas