How to find the Project size in Jira

[Venkata Sagar]

Hello Team,

I need to find out the project size in Jira , I have contacted the Database team . They asked me to get the Table name. Can anyone help me how to find out the table name.

Thanks,

Sagar

[Nic Brough -Adaptavist-]

What do you mean by "size"?

[Venkata Sagar]

Hi @Nic Brough -Adaptavist- ,

Thanks for the Reply!!

Actually database team asking for Table Name.

Can you help me how can i find the Table Name.

Thanks 
Sagar 

[Nic Brough -Adaptavist-]

Projects are smeared across dozens of tables, and they take up different amounts of space.

There's no answer to "we want a table name", it's useless to you without the context of the other tables that are part of a project.

We have to go back to what the actual question is.  What do you mean by "size"?

[Alessandro Lombardo]

You mean the number of issue per project?

[Venkata Sagar]

Hi @Alessandro Lombardo ,

Thanks for Reply!!

In How many Factors Project Size can be Find in Jira ?

Thanks,

Sagar

[Alessandro Lombardo]

Yes i think that. The table are "project" and "jiraissue" and you can count the number of issue per project.

you can use a query like that:

select count(*), p.pname from jiraissue i, project p where i.project = p.id group by p.pname, i.project;