SQL query to get unused custom fields in jira

Question

Hi Team,

I am using Jira software.

I wants a SQL query which will give me the details of unused custom fields or the list of custom fields which are not being used from long time, So that I can remove those custom fields as they are putting some performance impact on Jira.

Thanks,

Gajanan

Gajanan_Khule · Answer

Hi Fazila,

Thanks for you reply.

I have tried all the queries given on provided link.

But its doesn't feel my requirement.

I want the list of unused custom fields means the custom field which are not getting used in any issue on any project on jira.

The queries provided on the given link gives me the custom filed name even though that filed is getting used in some issue.

Thanks,

Gajanan

Fazila Ashraf · Answer

@Gajanan_Khule  ,

Can you look at https://community.atlassian.com/t5/Jira-questions/How-to-get-unused-custom-fields/qaq-p/267168 and try out the suggestions given there?