Best way to audit custom field use

[Esther Strom]

We recently had a consultant migrate a lot of data from a Rally system into our Cloud Jira instance. In the process, dozens of custom fields were created. I suspect that many of them only have a few issues with actual data in the fields.

What's the best way for me to find which fields are actually being used - not just on a screen, which I already know, but actually have values in the field?

Ideally, I'd get a list of all custom fields, each with a count of how many issues have a value in that field.

Is there a plugin that would give me a report of this info? Or do I have to just write a separate JQL query for each field and see how many results come back?

[Hernan Halabi - Elite IT Consulting Group]

I've seen this a lot when "consultants" don't pay attention to details, you will have to query each field or maybe another option is to query for any issue that has a value on the fields you care, export that to csv and analyze the data from there, then you should consider merging all the information from the duplicated fields into one. Scriptrunner is a good option to do that.

I suggest you check for extra resolutions or status as well, sometimes those are added as part of the migrations as well.