Report for to List of watchers Projects

[Domnic]

Hello, 

Is there a way I can generate/create a report where I have the name of the projects and the users who are watcher in the project.

Example:

Project Name | Watchers UserName

A                    | User1, User3, User100

B Two             | User20, User3, User 1, User6

C Three          | User1, User39, User50

D                   | User20, User35, User 3, User100, User6, User5

[Pablo Beltran _Marketplace Expert_]

If looking for an app, SQL Cloud can resolve it. 

Both questions would be resolved:

1) Make the requested report

2) Export it to Excel

[Domnic]

Hi @Pablo Beltran _Marketplace Expert_ 

When I search for it I could not find it in Manage app market place. Is this a free app?

[Domnic]

We do not user could version. Will it still work and could you share the link please

[Trudy Claspill]

If you are interested in using SQL queries against your database, you might want to look at these apps that can be used for Jira Server:

https://marketplace.atlassian.com/search?hosting=server&product=jira&query=SQL

[Domnic]

@Trudy Claspill I am looking for something which does not involve cost/licensing 

[Trudy Claspill]

Hello @Domnic 

Welcome to the Atlassian community!

Users are watchers of individual issues rather than entire projects.

Can you provide some context on the problem you are trying to solve by generating such a report?

[Domnic]

We want to do a audit/ know which users are watcher for Project A. I want to have a report where I can see for Project A who are the watchers and then for Project B Two. 

I have the project name and I need to find out the watcher on project level and not issue level

For example the report should be in two column. First column should be project name (I have the project names) Second column should be watchers (list of watcher should display)

[Trudy Claspill]

Hello @Domnic 

There is no built-in report for this. I have not found a third party app that can provide this, but I have not done an exhaustive analysis. You may find a third party app that you could use to get the information you want.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=report

Without a third party app, the only options I can think of is to use the Jira REST API to retrieve the watchers for each issue in a project, and programmatically compile that into a list and remove duplicates.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-watchers/#api-rest-api-3-issue-issueidorkey-watchers-get

[Domnic]

Hi @Trudy Claspill 

Would you know how I can get a excel for Project name | Users (active or Inactive) | Permission  Group 

Thanks,
Domnic

[Trudy Claspill]

Would you know how I can get a excel for Project name | Users (active or Inactive) | Permission  Group 

@Domnic 

That is an entirely different question than your original post. Please start a new Question for it.

[Domnic]

Hello @Trudy Claspill 

Thanks for suggesting that it is the different than my first question and will open a new post. But want I am  stilling wanting to know is how I can get the data as my first question. 

Could you suggest how I can use Jira Rest API to get the data I need. Just so you know I am a new user so I might ask multiple question.

Thanks, 
Domnic

[Trudy Claspill]

You can find documentation about the REST API here:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/