List of Jira Projects: Can I use a filter (and what syntax) to get a list of all jira projects ?

[Burkhard Schmidt]

Hi,

currently I'm supporting a transformation to move  Jira from on Premise to cloud.

To start preparing this I need a list of all the projects  having the project name/Key, Project Lead, Last Iissue update and Issues (#of Issues) to start prioritizing them.

Is there a chance to get this list out of a JQL?
Who might give me a helping hand?

Thanks
Burkhard

[Adrien Low _ServiceRocket_]

Hello @Burkhard Schmidt ,

For your information, JQL is only used to query Jira issues and not projects.

A common way would be to access the Projects page in the upper right corner which would have all the information you need:-

• Settings -> Projects

If you would like to export the list, perhaps you can consider querying from the database since the source instance is on-prem.

• https://confluence.atlassian.com/jirakb/retrieve-project-information-from-jira-s-database-1044111930.html

Hope this helps.

Regards.