How to fetch the Bamboo Data Center project details with the plan key
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
The purpose of this page is to provide a DB query which will help fetch Bamboo project details by providing the Bamboo plan_key.
The content on this page relates to platforms which are supported; however, the content is out of scope of our Atlassian Support Offerings. Consequently, Atlassian cannot guarantee support. Please be aware that this material is provided for your information only and you may use it at your own risk.
Building SQL statements for reporting purposes is not part of the Atlassian Support scope and this work is provided "as-is", on a best-effort basis. Queries may work better or worse than expected, your mileage may vary. It is up to each customer to analyse each query individually and understand if that is enough for their specific needs.
Environment
The query has been tested for PostgreSQL and MySQL DB's along with Bamboo 9.2.6
Solution
To fetch Bamboo project details for a particular plan key
1
2
3
4
5
6
7
8
9
SELECT DISTINCT p.PROJECT_KEY,
p.TITLE,
b.FULL_KEY AS plan_key,
b.TITLE AS plan_name
FROM PROJECT p,
BUILD b
WHERE p.PROJECT_ID = b.PROJECT_ID
AND b.FULL_KEY = 'plan_key'
ORDER BY p.TITLE ℹ️ Please replace plan_key with the correct plan_key for which you need the details.
To get the details for all the Bamboo projects and the plans associated with them.
1
2
3
4
5
6
SELECT DISTINCT P.PROJECT_KEY,P.TITLE,B.FULL_KEY AS plan_key,B.TITLE AS plan_name
FROM PROJECT P, BUILD B
Where P.PROJECT_ID = B.PROJECT_ID
AND B.build_type = 'CHAIN'
ORDER BY P.PROJECT_KEY
Was this helpful?