SQL query to determine which forms / projects a custom field belongs to

Dav1d J0nes

I have some duplicate custom fields I need to clean up and I'd like to be able to run a single SQL query so i can quickly see who i need to contact to clean it all up 

so essentially id like to be able to select the project name, form name, field name, field id for fields x,y  and z 

Nic Brough -Adaptavist-

You as well as project name, screen name, field name, field id, you're going to need to consider

• issue type
• screen scheme
• issue type screen scheme
• field configuration
• field configuration scheme
• field contexts
• workflow
• workflow scheme

As you can imagine, you are not going to get that with any quick simple SQL.