Best way of finding unused/Empty custom fields

Vikrant Yadav
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 30, 2023

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

Screenshot 2023-01-30 191339.png

Thanks,

Vikrant Yadav

1 answer

1 accepted

0 votes
Answer accepted
Ram Kumar Aravindakshan _Adaptavist_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 6, 2023

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 9, 2023

Thanks a lot @Ram Kumar Aravindakshan _Adaptavist_ 

🥳😊

Suggest an answer

Log in or Sign up to answer