Summary

When using plan branches, it's possible to configure whether they will be automatically cleaned up or not. The clean-up settings are set under the main plan branch configuration >> "Branches" tab >> "Delete plan branch" section, and they default to 7 days after deletion and 10 days of inactivity. For each plan branch, under the branch configuration >> "Branch details" tab, you can use the "Clean up plan branch automatically" checkbox to determine if that branch will or will not be cleaned up automatically. If the "Clean up plan branch automatically" checkbox is marked, the branch inherits the global plan values defined in the main plan and can eventually be deleted automatically by Bamboo; if unmarked, the branch will not be deleted automatically.

This article covers a SQL query to easily identify which plan branches have the "Clean up plan branch automatically" box checked and which do not.

Environment

This was tested on Microsoft SQL Server 2019. 

Solution

SELECT
       (
           SELECT B1.TITLE
           FROM BUILD B1
           WHERE B1.BUILD_ID = B.MASTER_ID
       ) AS PLAN_NAME,
       B.TITLE AS PLAN_BRANCH_NAME,
       B.FULL_KEY AS PLAN_BRANCH_KEY,
       CASE
            WHEN BD.XML_DEFINITION_DATA LIKE ('%<cleanup>%<disabled>false</disabled>%</cleanup>%')
                THEN 'CHECKED'
            WHEN BD.XML_DEFINITION_DATA LIKE ('%<cleanup>%<disabled>true</disabled>%</cleanup>%')
                THEN 'UNCHECKED'
            ELSE ''
            END AS CLEANUP_BRANCH_CHECKED,
       CONCAT('<BAMBOO_URL>/branch/admin/config/editChainBranchDetails.action?buildKey=',B.FULL_KEY) AS URL
FROM BUILD_DEFINITION BD
JOIN BUILD B on BD.BUILD_ID = B.BUILD_ID
WHERE B.BUILD_TYPE = 'CHAIN_BRANCH'
ORDER BY PLAN_BRANCH_KEY