How to get list of all fields that were never used in Jira

[Ashish Bijlwan]

How to get the list of all fields that were never used in Jira including the custom field and associated issue types.

[Nic Brough -Adaptavist-]

You can't really do this in plain Jira - the best you can do is report on how fields HAVE been used, and subtract that from a list of fields that exist.

I'd strongly recommend looking at the housekeeping or migration apps in the marketplace, as they can easily report on actual usage.  Project Configurator, Configuration manager, Microscope, Cleaner and and and...

[Ashish Bijlwan]

Hi @Nic Brough -Adaptavist- 

Could you please share screenshot or steps to know ow fields HAVE been used, and subtract that from a list of fields that exist.

Thanks,

[Nic Brough -Adaptavist-]

It's manual, but you could script it with an app, or even just use one of the apps that does report on it directly.

Check you have the ability to see all issues within all the projects (note that Admin rights give you admin, not "can see everything", and you may need to grant yourself access to projects you can't see)

• Run the JQL "" or something simple like "order by updated" - this will list every issue you can see, and you are just interested in the 
• Go to Admin -> Issues -> Custom Fields
• Get the list of all fields (you probably want to scrape it all into a doc somewhere)
• For each field, run the JQL
  • <field> is empty.  Compare that with the total number of issues
  • <field> is not empty.  Look at the results to judge how and where it's in use

This isn't quite "show usage and subtract", it's the next step down the road

[Mayur Jadhav]

Hi @Ashish Bijlwan 

Atlassian has  already written an complete Knowledge Base article to deal with the problem of unused or poorly used custom fields.

Managing custom fields in JIRA effectively

https://confluence.atlassian.com/enterprise/managing-custom-fields-in-jira-effectively-945523781.html

[Ashish Bijlwan]

Hi @Mayur Jadhav 

Thank you for sharing the URL, I have already gone through with the link. I am looking a way to get the unused or poorly used custom fields via Jira it's using some JQL or Script without installing any plugin.

Thanks,