Best way to get list of all unused custom fields data in Jira

[manikanta ch]

Best way to get a list of all unused custom fields data in Jira

[Ste Wright · Accepted solution]

Hi @manikanta ch 

There's a really great Knowledge Base article on managing custom fields - see this page here.

Let us know if this helps or if you'd like any further suggestions :)

Ste

[manikanta ch]

Hi @Ste Wright ,

I have deleted all unused screens and inactive workflows and i ran the below SQL query as mentioned in the article to rertive all unused custom fields but SQL query is not getting correct data. The fields list the Query listed is attached to screens and workflows. We want rertive the unused custom fields data which are not attached to any screens, workflows or used in any tickets.

select count(*), customfield.id, customfield.cfname, customfield.description
from customfield left join customfieldvalue on customfield.id = customfieldvalue.customfield
where customfieldvalue.stringvalue is null 
and customfieldvalue.numbervalue is null 
and customfieldvalue.textvalue is null
and customfieldvalue.datevalue is null
group by customfield.id, customfield.cfname, customfield.description;

Could you please let me know if there is any other query to get unused custom fields data?.

Thanks,

Mani 

[Ste Wright]

Hi @manikanta ch 

Not sure on the query - but an alternative could be to use an app to clean-up your instance?

For example, apps such as Power Admin or Optimizer for Jira could be helpful here!

Ste