How can I get a list of fields used in JIRA?
This query will list field information by field configuration.
SELECT fl.Name as `FieldConfiguration` , f.* FROM fieldlayoutitem f INNER JOIN fieldlayout fl on fl.ID = f.fieldlayout;
This query is written for MySQL. You may need to tweak the syntax to get it to run in another DB.