Export Custom Field usage report

[Mohana Sundar J]

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.

[Mohana Sundar J]

Hello Mark,

Thank you for your suggestion. 

I already have a list of Custom fields for which I need the details.

• 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

So basically like:

Custom Field	Project	Key	Project Administrator
Client Name	Project 1	P1	User1, User2, User 3….. N
	Project 2	P2	User1, User2, User 3….. N
	…	…	…
Client Email	Project 3	P3	User1, User2, User 3….. N
	Project 4	P4	User1, User2, User 3….. N
	Project 5	P5	User1, User2, User 3….. N
	…	…	…

[Mark Segall]

If the number of fields you're trying to review are manageable, you could create a dashboard with two-dimensional filters for each custom field measured against  project.  This will give you totals and then you can click on each total to get a detailed list of issues.

Otherwise, your best bet is still to export the result set to csv and create the report outside of Jira.

[Mohana Sundar J]

Dear @Mark Segall Unfortunately, this couldn't meet my requirement. We have thousands of projects, so it would be difficult to fetch it this way. I really appreciate your time and effort and support :) 

[Mark Segall]

Based upon that, your best options are:

• Get someone who is savvy with scripting to get this info via the API and either dump it in a database or csv
• Use a 3rd party reporting tool like Tableau or EasyBI to pull the data