Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

SQL Query to find All Deployment Projects

Mahendra Singh Bisht November 30, 2022

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.



1 answer

0 votes
Eduardo Alvarenga
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 30, 2022

Hello @Mahendra Singh Bisht

Welcome to Atlassian Community!

The two questions are covered by the following KB article:

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 December 1, 2022

Hi Eduardo,

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

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events