Export Custom Field usage report

Mohana Sundar J_gq0y5i

Hi All,

 

I would like to export a report on the usage of custom fields for audit purposes.

• List of Projects (Project Name and Project Key) associated with the custom field
• List of users in the Project Administrator role for the above list of projects

 

Any suggestions would be helpful. Thanks in advance  

 

 

 

Mark Segall

Hi @Mohana Sundar J and welcome to the community!

I'll defer to the scriptrunner gurus on whether there's a way to do this elegantly via that mechanism, but natively, you could do this (could be quite painful though depending upon how many issues you have in the system):

Perform a wide open search (I would look at the last 6 months to a year as a starting point to see what's being used recently):

created >= -365d

Use the Export CSV All Fields option.  Then in your Spreadsheet app of choice, create a pivot table broken down by custom field and project to get a count of how many issues are using each of the fields by project

Of course, the pain point is that you can only export 1k issues at a time so you may need to run through the export several times.