Bamboo Database Table/Field Location of Projects/Linked Repo controlled via Bamboo Specs

[Conor O'Higgins]

Hi, 

I’m trying to find the location in the DB for the field(s) that stores the status of a project that is controlled via Bamboo Specs. Such as on the UI as shown below:

There is a db table vcs_location that has a xml_definition_data that captures all of the repository settings however the config bamboo.specs.enabled captures which projects have specs enabled as an option in the UI but it doesn’t differentiate between projects that are controlled by specs and those that aren’t but only have the setting enabled.

The bamboo version I'm using is: 7.1.1

Thanks.

[Eduardo Alvarenga · Accepted solution]

Hi @Conor O_Higgins

The information you are looking for is contained in the PLAN_VCS_SPECS_SOURCE table. Here is a query that will return the Plan Id, Plan Key and RSS repository name. You can adapt it to your specific requirement.

SELECT S.PLAN_ID  AS "Plan Id",
       B.FULL_KEY AS "Plan key",
       VL.NAME    AS "RSS Repository"
FROM   PLAN_VCS_SPECS_SOURCE S
       JOIN BUILD B
         ON B.BUILD_ID = S.PLAN_ID
       JOIN VCS_SPECS_SOURCE V
         ON V.VCS_SPECS_SOURCE_ID = S.VCS_SPECS_SOURCE_ID
       JOIN VCS_SPECS_STATE VT
         ON VT.VCS_SPECS_STATE_ID = V.VCS_SPECS_STATE_ID
       JOIN VCS_LOCATION VL
         ON VL.VCS_LOCATION_ID = VT.VCS_LOCATION_ID 

Kind Regards,

Eduardo Alvarenga
Atlassian Support APAC

[Conor O'Higgins]

Thanks @Eduardo Alvarenga this worked a treat. Thanks!

[Eduardo Alvarenga]

Thank you @Conor O_Higgins

I've created a KB article that demonstrates that and more:

• How to locate Build plans an Deployment projects/environments that are bound to Repository Stored Specs

Regards,

Eduardo Alvarenga
Atlassian Support APAC