How to find the user who performed a deployment in the Bamboo database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
It may be necessary for data auditing, retention and reporting purposes to identify the user who executed a manual deployment in Bamboo via the database.
Solution
The user who executed the deployment can be found within the DEPLOYMENT_RESULT_CUSTOMDATA table. It is stored with a CUSTOM_INFO_KEY of 'ManualBuildTriggerReason.userName' under the CUSTOM_INFO_VALUE column.
Here is an example query which performs all the relevant joins to tie in deployment related information and filters for deployments with a triggering user:
SELECT DP.*, DE.*, DR.*, DRCD.* FROM DEPLOYMENT_RESULT DR
JOIN DEPLOYMENT_RESULT_CUSTOMDATA DRCD ON DR.DEPLOYMENT_RESULT_ID = DRCD.DEPLOYMENT_RESULT_ID
JOIN DEPLOYMENT_ENVIRONMENT DE ON DR.ENVIRONMENT_ID = DE.ENVIRONMENT_ID
JOIN DEPLOYMENT_PROJECT DP ON DE.PACKAGE_DEFINITION_ID = DP.DEPLOYMENT_PROJECT_ID
WHERE CUSTOM_INFO_KEY = 'ManualBuildTriggerReason.userName';