SQL - How many users in a project?

Andris Grinbergs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 6, 2014

Are there SQL select sentence around (For Jira 5 or 6) which displays exactly how many users have "Browse Project" permission for specified proejct?

By taking into account individual users in permission scheme, users in groups and users in roles.

1 answer

0 votes
Tiago Comasseto
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 6, 2014

Hi Andris, here you can find some examples of SQL queries, I believe you can adjust them to retrieve the information you want.

Cheers

Andris Grinbergs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2014

Hi,

Thank you for suggestion, I'll take a look.

Andris.

Suggest an answer

Log in or Sign up to answer