SQL Query to find All Deployment Projects

Question

Hi Team,

Can someone help me with the SQL queries to generate the following from the Bamboo Database:

* All Deployment Projects
* Previously Deployed Releases details after we select the Environment in the All Deployment Projects.

Regards,

MS

Mahendra Singh Bisht · Answer

Hi Eduardo,

Thank you for your assistance here, I will check and get back to you on this.

Eduardo Alvarenga · Answer

Hello @Mahendra Singh Bisht

Welcome to Atlassian Community!

The two questions are covered by the following KB article:

* How to relate a release with deployment project, environment and build plan in Bamboo database

You may have to reduce the SQL to retrieve only the "deploy_proj_name" portion to fulfil your first question.

Kind regards,

Eduardo Alvarenga
Atlassian Support APAC

--please don't forget to Accept the answer if the reply is helpful--