i need inactive custom fields and active custom fields from mysql

[Mahendar]

Hi team,

i need custome filed list from mysql database please guide me what are the querys to get the results.

we have 1000 fields but we are using only few of them i want to know which are not used by projects so please give me some querys 

[Tarun Sapra]

Hello @Mahendar 

Here's the possible duplicate, with sql query and an plugin alternate

https://community.atlassian.com/t5/Jira-questions/How-to-get-unused-custom-fields/qaq-p/267168