get list of all fields and their options used in service management project (cloud)
Welcome to the Atlassian Community!
For a team-managed project, go to project admin and look at the fields in use. For a company-managed project, go to global admin -> custom fields and work your way through the contexts for each field.
For a usage summary, your best bet is probably a set of gadgets on a dashboard, one for each field.
Create a filter for each field - "field X is not empty", then for and field of a list type (radio button, select list, user, multi-select, etc) create a gadget for "filter statistics" and tell it to group by project. For date, number, or text fields, the best you can do is "list issues", it will at least tell you how many entries there are.
Is there a way I can export the fields to an excel? I don't want to do time taking analysis of each field one by one when there are hundreds on them. If I have a full list, I can use formula's to do that for me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You could write a script to get some of the data into a spreadsheet, by scraping the lists from the REST API - I'd probably start at https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-fields/#api-group-issue-fields
But that is not going to include actual usage data - you're still going to need to run those searches (that can be done over the REST API as well)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.