Report of all Jira projects and screen schemes associated.

[Keshni]

Hi, 

What query can I use to give me a list of Jira projects with associated screens/screen schemes. 

Thank you :)

[Nic Brough -Adaptavist-]

If you go to Admin -> Screen Schemes, you'll see the full list (and there is an expandable area at the bottom for the inactive unused schemes)

[Keshni]

Hi @Nic Brough -Adaptavist- ,

Thanks for this. We run a server instance the under screen schemes, it shows us issue type screen schemes. 

I am looking for a SQL query to pull all project names and screens/screen schemes associated. 

[Nic Brough -Adaptavist-]

Ok, let's try another approach.  Why?  What would this tell you that the admin screens do not? 

You're still going to have to use the admin screens to reconfigure anything because you won't be updating the database with SQL, and the SQL for the query is pretty horrid to build and understand.  You will find the admin section a far easier way to understand what you've got.