Purpose

The information on this page is an extension to Locating important directories and files in which describes how to identify Deployment logs located in Bamboo home directory.

Solution

Run the following SQL statement against Bamboo's database:

select DP.DEPLOYMENT_PROJECT_ID, DP.NAME,
       DE.ENVIRONMENT_ID, DE.NAME,
       DR.DEPLOYMENT_RESULT_ID, DR.VERSION_NAME
  from DEPLOYMENT_PROJECT as DP
  join DEPLOYMENT_ENVIRONMENT as DE
       on DE.PACKAGE_DEFINITION_ID = DP.DEPLOYMENT_PROJECT_ID
  join DEPLOYMENT_RESULT as DR
       on DR.ENVIRONMENT_ID = DE.ENVIRONMENT_ID;

In response, you should get the following:

From the RED, GREEN and BLUE from spreadsheet above, we identify the DeploymentResult log file in Bamboo's home directory structure: