How to get Jira project statistics?

user2_7mx5am

To whom it may concern

I am looking how to get a Jira project size and pages. # of attachment, attachment size information. Jira is using Microsoft SQL server on-premises.

I used the script below, and I get "Invalid object name 'CONTENT'."

select count(CONTENTID) as "number of attachments", SPACES.SPACENAME from CONTENT
join SPACES on CONTENT.SPACEID = SPACES.SPACEID
where CONTENT.SPACEID is not null
and CONTENT.PREVVER is null
and CONTENT.CONTENTTYPE = 'ATTACHMENT'
group by SPACES.SPACENAME
order by "number of attachments" desc;

Thanks in advance

Barton

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

Yeah, this is another reason for not looking at any Atlassian database.  Your SQL isn't for Jira, it's for Confluence.

And it's wrong, because you're not going to get the right information from it.

Forget the database, you're wasting your time.  

For Jira attachment size, look at your server - the simplest option is to look at the size of the directory <your jira data directory>/attachments

Jira "project size" is not an easy calculation - you'd need to read every part of Jira that stories bits of issues, look at the content in there, and reverse-engineer exactly how the database stores each line in the tables in the files the database is made up of.