Trying to find out in which Issue type scheme which issue type is used

[Tabe Nyenty]

I will like to know which issue type scheme is using which issue type. I therefore tried the following but the result is incomplete as there are far more issue type scheme within our system. What am I missing?

select issuetype.ID, issuetype.pname, issuetypescreenscheme.NAME, issuetypescreenscheme.ID, issuetypescreenschemeentity.ISSUETYPE,
issuetypescreenschemeentity.SCHEME
from issuetype, issuetypescreenscheme, issuetypescreenschemeentity
where issuetype.ID = issuetypescreenschemeentity.ISSUETYPE
and issuetypescreenscheme.ID = issuetypescreenschemeentity.SCHEME

Any help appreciated,

Thanks 

[Tinker Fadoua]

Hi Tabe,

Do you have access to JIRA as a JIRA ADMIN?

Are you s jira cloud or server user?

[Tabe Nyenty]

Hi Fadoua,

Yes i have access to JIRA as an ADMIN and I´m also a server user

[Tinker Fadoua]

Why don't you do it from the Admin Console? Instead of the code above? May be I am missing something which I apologize

[Tabe Nyenty]

You´re missing something this can´t be done from the Admin console if so I´m not really sure on how to proceed here.