SQL query to get list of Field configuration and field configuration scheme

[pradeep km]

Team can you help me to get total  list of filed configuration and field configuration scheme in JIRA server.
List should contains name.

[Nic Brough -Adaptavist-]

There isn't one.  Parts of the list you are looking for is done in the code, and SQL can't return what isn't there.

SQL is the worst possible way you can get any information out of a Jira system.  It's a last resort and should be avoided.

Could you explain what you are trying to achieve?  We can almost certainly give you a far better way to get what you are looking for.

[pradeep km]

We are migrating from server to DC so we need this data for comparison.

[pradeep km]

@Nic Brough -Adaptavist- 
Let me know who can help on this topic.
We have any team to support on this topic..?

[Nic Brough -Adaptavist-]

Read it from the UI which can give you the actual information you want to be using to do your pre migration housekeeping.

[pradeep km]

@Nic Brough -Adaptavist- 
Hope you are clear about my requirement and yes we will get it by reading from UI no issue in that but we need extract.
If  you cant help or if you dnt know u  can say  "No".

[Nic Brough -Adaptavist-]

No, I am not clear on the requirement.

What are you actually trying to achieve here?  What would you do with a vast long list (with missing data) of field configuration settings?

[pradeep km]

@Nic Brough -Adaptavist- 
No worries I got my SQL query.

[Nic Brough -Adaptavist-]

Please bear in mind that it is wrong, and hence probably going to mislead you.

[Divya TV]

Nic, We have over 5000 projects.  And have around 10 to 15 field configuration scheme.

In the UI, the field configuration scheme and the projects using it are listed.

There is no numbering. My management wants to know how many projects are using a particular field configuration scheme. How can I achieve that? I cant count from the UI, there are over 400 in one and then they are not numbered. Perhaps there must be another way?

[Nic Brough -Adaptavist-]

Faster than SQL (which will give you the wrong numbers anyway) - copy and paste the view of the list in the admin screen into a text editor and then use a counting tool on it ( "cat temp.txt | wc" for example).

But, why does your management care how many projects are using a field configuration?  Do you have a set of teams being crippled by micro-management?