Deployment logs in Bamboo Server
目的
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.
ソリューション
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:
DEPLOYMENT_PROJECT_ID | 名前 | ENVIRONMENT_ID | 名前 | DEPLOYMENT_RESULT_ID | VERSION_NAME |
---|---|---|---|---|---|
720897 | デプロイメント | 851969 | 環境 | 6881281 | release-1 |
720897 | デプロイメント | 851969 | 環境 | 6881282 | release-2 |
From the RED, GREEN and BLUE from spreadsheet above, we identify the DeploymentResult log file
in Bamboo's home directory structure:
|