Best way of finding unused/Empty custom fields

[Vikrant Yadav]

Hi Guys,

Need your help in cleaning our jira instance. What is best way of finding empty/unused field. I am Using JIRA provided Custom field optimizer  , but it won't count Archived issue or Archived project, for these it's showing zero issue count. What is the best way to find field which include both archived and active issues. 

As you can see the screenshot, Last value update is 23rd Nov 2022 but issue is showing zero and jql query is also showing zero count.

I want to know which field I consider for deletion. Which is having issue count =0 or in which last value update is never ? 

Kindly help me with parameters which i need to check before deleting any custom field. 

Using sql query mentioned in this link, i can find field usage but I think it won't count Archived issue. My main concern is how to check field is used with archived issue or not. Please suggest

Thanks,

Vikrant Yadav

[Ram Kumar Aravindakshan _Adaptavist_ · Accepted solution]

Hi @Vikrant Yadav

There has been a similar discussion on this topic in this Community Post.

You can refer to this Atlassian KB for more information.

Basically, you will need to execute this SQL Query to get the details:-

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;

I hope this helps to solve your question. :-)

Thank you and Kind regards,

Ram

[Vikrant Yadav]

Thanks a lot @Ram Kumar Aravindakshan _Adaptavist_ 

🥳😊