I want to get the full projects report in a data center jira instance.

[Kishore D]

I am trying to get full projects reports from jira instance. Details i want to fetch are like,
PROJECT NAME
PROJECT KEY
Template/Scheme PROJECT using
PROJECT OWNER
Team Name.

Is there any way i can get these details with less effort?

[Fabio Racobaldo _Herzum_]

Hi @Kishore D ,

you can retrieve all these information using the following REST api https://docs.atlassian.com/software/jira/docs/api/REST/9.3.1/#api/2/project-getProject

Hope this helps,

Fabio

[Kishore D]

Hi @Fabio Racobaldo _Herzum_ ,

I have tried Rest api call to fetch project list. But, in jira system info it was showing 865 (active) projects , where as in rest api i got 232(active) project.

I feel like this is not accurate.

API used: https://jira.datacenter.net/rest/api/latest/project 

can you suggest any alternate way to get accurate data of projects and its keys.?

any other way, to fetch data from Database table name, column names?

[Fabio Racobaldo _Herzum_]

Hi @Kishore D , please verify that you are using the correct user to get that info from JIRA. Probably, 232 are the projects visible by the user used in the api call.

[Kishore D]

Hi @Fabio Racobaldo _Herzum_ ,

I am jira admin and its not listing full details. 
To cross verify, i want to check from database. 

Can i have Table name which will have  all project names stored?

[Fabio Racobaldo _Herzum_]

This is your SQL query :

SELECT *
FROM project;

[Kishore D]

Thanks @Fabio Racobaldo _Herzum_ ,

Need  some  more info,

Need table details of  "Team Name",  

Template/schemes used by project . Need this details so can you share table name for this too

[Fabio Racobaldo _Herzum_]

Schemes are located in different tables : fieldscreenscheme, schemepermissions, notificationscheme and so on.

Please, take a look here https://developer.atlassian.com/server/jira/platform/database-schema/

Fabio