How to know whether a custom field/ work flow/ issue type was ever used or not ?

Question

Hi all. We have so many custom fields, work flows and issue types in our system. Due to this we are experiencing performance issues. Can someone provide the sql query to know custom fields, workflows and issue types that are never used. We want to clean up our system. Any sort of help is appreciated.

Jonnada Kiran · Answer

Thanks Kian.

Kian Stack Mumo Systems · Answer

Hello,

This article has a lot of potential solutions for you. I think it will be helpful.

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

Thanks,

Kian