Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Exporting a list of all projects from on premise JIRA

Exporting a list of all projects from JIRA server. I want below details:

Project name + Key
Project owner
Date last updates
Number of issues

 

3 answers

1 vote

Hi @Ravi Gupta ,

 

If you have Jira Administrative access. from front end you can try copy pasting these from Excel.

 

Settings icon --> projects -->

where you can see all your projects, Lead, total number of issues, last issue updated and etc.

You can copy these details and post in excel as Text. this will be easy.

 

Thanks,

Kagithala Babu Anvesh

@KAGITHALA BABU ANVESH We have around 800 projects and its time taking task.

Any other options?

Hi @Ravi Gupta ,

 

Yes, with Jira REST API, I just checked. The API is showing deprecated.

Can you please check the below.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-projects/ 

Please check the REST API's, These may be helpful

 

Thanks,

Kagithala Babu Anvesh

Hi @Ravi Gupta

I'm Leo from DEISER (Solution and Makertplace Partner)

Have you tried Projectrak?
https://confluence.deiser.com/projectrak/8.1.1/export-to-excel-110953960.html 

 

With Projectrak you can export to excel your projects, also, you can create some script fields like "Date last updates" or "Number of issues", this is an example for "Number of issues":

package deiser.profields.scripts

import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.jql.builder.JqlQueryBuilder
import com.atlassian.jira.web.bean.PagerFilter


// Components
def searchService = ComponentAccessor.getOSGiComponentInstanceOfType(SearchService.class)
def jiraAuthenticationContext = ComponentAccessor.jiraAuthenticationContext

// Script variables
def loggedInUser = jiraAuthenticationContext.getLoggedInUser()

// Make JQL query
def query = JqlQueryBuilder.newBuilder()
        .where()
        .project(project.id).and()
        .buildQuery()

// Returns the issue count
return searchService.search(loggedInUser, query, PagerFilter.unlimitedFilter).results.size()

I hope it helps you!

Try Projectrak:
https://marketplace.atlassian.com/apps/1210816/projectrak-project-tracking-for-jira?hosting=datacenter&tab=overview 

Leo

0 votes

@Ravi Gupta 

Have you tried the project export feature of Better Excel Exporter?

You can get your projects into a real Excel file with a single click:

jira-project-export.png

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you