Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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


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:


Screenshot 2022-08-10 at 16.23.08.png


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


1 answer

1 accepted

0 votes
Answer accepted

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.

       B.FULL_KEY AS "Plan key",
       VL.NAME    AS "RSS Repository"
         ON B.BUILD_ID = S.PLAN_ID

Kind Regards,

Eduardo Alvarenga
Atlassian Support APAC

Thanks @Eduardo Alvarenga this worked a treat. Thanks!

Thank you @Conor O_Higgins

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


Eduardo Alvarenga
Atlassian Support APAC

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events