SQL Query to find All Deployment Projects

[Mahendra Singh Bisht]

Hi Team,

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

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

Regards,

MS

[Eduardo Alvarenga]

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

[Mahendra Singh Bisht]

Hi Eduardo,

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