Report of all Jira projects and screen schemes associated.

Question

Hi,

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

Thank you :)

Nic Brough -Adaptavist- · Answer

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.

Keshni · Answer

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- · Answer

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)