Statistics - how to list all total tickets in each project

[James Fama]

Good afternoon Atlassian Community,

We have DSAR / Audit request from our compliance. We want to list all the total tickets of each project. 

I am an org admin and site admin in our tenants. The only thing is that when you run this query under my credentials it doesn't display  the projects and tickets that you don't have access. 

Is there any method you can run a command  or use a tool or an API call or JQL that will list all the total tickets in each project regardless if you have access or you don't have access to the project. 

Please let me know if you have any suggestions or answer.

Thank you,

James

[Nic Brough -Adaptavist- · Accepted solution]

No, you have to be able to see the issues to run reports on them.

The API and JQL respect the permissions you have set, there's no way to see issues you have no permission to see.

[James Fama]

@Nic Brough -Adaptavist- Thank you for quick answer. So, do you have any suggestion to overcome this building block? 

[Nic Brough -Adaptavist-]

You need to work through your project permissions, granting yourself browse permission to all of them (or the aggregated reporting browse)

[James Fama]

Thank you @Nic Brough -Adaptavist-  what is the fastest way to add myself over 150 software projects? Any short cut way? 

[Nic Brough -Adaptavist-]

There's no shortcuts to this, unless you are willing to script something that can amend your permission schemes over the REST API.

[Sanjog Sigdel]

@James Fama If you get the permission of Jira Site Admin or the Global Asministrator, you'll  have permission to all 150 projects.

Please contact your jira administrator getting necessary approval, for them to grant you access.

[Nic Brough -Adaptavist-]

This is incorrect.

Admin rights give you admin rights, not "can see/do anything"