Problem Definition

For auditing purposes, customers may require reports that will display the Jira issues associated with certain deployment projects or releases on a period of time.

Suggested Solution

Implement reporting capabilties in Bamboo such that will generate reports displaying Jira issues based on the deployments and dates selected.

Workaround

You can get the deployment projects or environments associated with a Jira issue using the below two endpoints:

• /deploy/issue-status/{issueKey}
• /deploy/issue-status/{issueKey}/{deploymentProjectId}

Alternatively, you can use the below SQL script as a reference to fetch the Issue IDs associated with a deployment or environment. Note that this is just an example which may not include all the details you require.

select dp.deployment_project_id, de.environment_id,de.name,dr.deployment_result_id, dr.finished_date,dv.deployment_version_id, dv.name, dv.creator_username, dvji.jira_issue_key,dvji.dep_ver_jira_issue_id from deployment_project dp join deployment_environment de on dp.deployment_project_id = de.package_definition_id join deployment_result dr on de.environment_id = dr.environment_id join deployment_version dv on dr.version_id = dv.deployment_version_id join dep_version_planresultkeys dvp on dv.deployment_version_id = dvp.deployment_version_id join deployment_version_jira_issue dvji on dv.deployment_version_id = dvji.deployment_version_id;