Jira Workflow Schemes Fields usage reports

Is there a way to get usage statistics for JIRA workflows,  Field schemes, Issue Types schemes, Screen schemes  and custom fields. We are planning to upgrade and do not wantto include schems & custom fields NOT USED. What kind of report is avilable or used for internal JIRA developers?   Any script we can run against Oracle database that can give us usage statistics? Example: How many times a custom field has been populated, workflows not used in any project? Schemes not used in any project?

3 answers

1 accepted

For custom field usage in particular, Oracle may be easier, as you can run a single query to count how many values have been set for each custom field, or just pick out the fields that have never been used.  Using a Mysql example, it (unused custom fields) would be:

select count(cfv.id), cfname, cf.id from customfield cf left join customfieldvalue cfv on cf.id=cfv.customfield group by cf.id, cfname having count(cfv.id) = 0;

Don't pull cf.id from the query or else custom fields with duplicate names will be lumped together.  If you want full usage, use:

select count(cfv.id), cfname, cf.id from customfield cf left join customfieldvalue cfv on cf.id=cfv.customfield group by cf.id, cfname order by 1,2;

There may be single-use custom fields out there that really are adding no value as well, and could be removed.

For the rest, I agree with Nic, JIRA shows which schemes are not in use readily in the UI, cleaning those up is a straightforward exercise; figuring out the database table for each scheme, and the referencing column/table to do a similar query is likely more work than it is worth.

0 vote

You could dig through the database, but it's probably easier to just use the UI.

For example, for each custom field run a filter for <customfield is not empty> to see how much it's been used.  For workflows, look at the list of workflows and just delete all the ones in the "inactive" section.  For screens, start at the issue type screen scheme page and delete all the ones not mapped to a project, then go to screen schemes and delete all the ones not mapped into an issue type screen scheme, and then delete any screens not used by any workflows or screen schemes. 

0 vote

I wish there was an easier way to do all this

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

90 views 0 5
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you