Exporting a list of all projects from on premise JIRA

[RG]

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

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

[Levente Szabo _Midori_]

@RG 

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:

[KAGITHALA BABU ANVESH]

Hi @RG ,

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

[RG]

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

Any other options?

[KAGITHALA BABU ANVESH]

Hi @RG ,

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

[Leo Diaz - Deiser]

Hi @RG

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