How to Export of Users per Project?

[Branimir Kostic]

Dear all,

I'm owning a small Jira Cloud instance with around 200 users. It started small with around 10 users so that we could easily manage that by our own. After some time the number of users increased and therefore also to wish to monitor the list of user per project.

Unfortunately I could only find a way how to export all users but there is no option to get an export per Jira project. Why i would need it is that sometimes I want to write some emails to users of a specific project.  I would love to at least export the list of users of one project and then send the email (if there is not another, more easier way).

But it seems that it's not possible without any paid version. How are you doing it? How can I use the REST API in a simple way (for free) for example with Google Sheets, App Scripts or something similar.

Thanks a lot in advance

[Jack Brickey · Accepted solution]

Hi @Branimir Kostic , your findings are correct that you cannot export users per project. Actually there isn't a way to query users un a project. If you could then you could export. One option is to create a group for the project and add the project users into the group. Then you could export per group. You might also consider an addon app.

[Branimir Kostic]

Hi @Jack Brickey Thanks  a lot for your answer. I assumed that. Most likely I will follow your proposal and create a dedicated group per project. 

Another idea that I tried is to go via Roles, but the roles are not project related so 

I was thinking about an addon app, but I would still consider this as a basic function that Jira should provide. But instead for everything you need an addon, which again generates additonal costs.

[Prince Nyeche]

Via API it is possible. First, you need to know the number of active users you have on the instance then you need to run across each user who has access to browse a particular project. Do that continuously until you exhaust the list of users then collect those data to create a CSV file of users in a project. So a combination of user search API, and project API should give you the result you need.

[Manuela]

A small note: also remember to export groups, because users in these groups will also have specific access to the project. Without exporting groups, the information may be incomplete

[Aron Gombas _Midori_]

You could eventually solve the use case with announcements. So, display the information you wanted to email as an announcement. 

There are several apps that can do that: https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=announcement

The question is, can you display the announcement only if the user is in project X? I don't have an answer for that, but you could do your research.

Or, if you are using dashboard for the project, then you could use the gadget which display free text to display the information in the project dashboard.