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.