Location of Jira issue keys in Bamboo
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 BRS_LINKEDJIRAISSUES and DEPLOYMENT_VERSION_JIRA_ISSUE are the tables used by Bamboo to store Jira issue key with Bamboo build and deployment relationship and can be fetched with the SQL below.
Find Jira Issues in a plan regardless of how many build results the issue key is present for a plan
1 2 3 4SELECT DISTINCT(BL.JIRA_ISSUE_KEY) AS "Issue Key", BS.BUILD_KEY AS "Plan Key" FROM BRS_LINKEDJIRAISSUES BL JOIN BUILDRESULTSUMMARY BS ON BS.BUILDRESULTSUMMARY_ID=BL.BUILDRESULTSUMMARY_IDList of Jira issues associated with Releases and respective Deployment projects
1 2 3 4 5 6 7 8select distinct (DVJI.JIRA_ISSUE_KEY), DV.NAME RELEASE_NAME, DP.NAME DEPLOYMENT_PROJECT_NAME from DEPLOYMENT_VERSION_JIRA_ISSUE DVJI join DEPLOYMENT_VERSION DV on DVJI.DEPLOYMENT_VERSION_ID = DV.DEPLOYMENT_VERSION_ID join DEPLOYMENT_PROJECT DP on DV.PROJECT_ID = DP.DEPLOYMENT_PROJECT_ID;
Was this helpful?