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
4,369,537
Community Members
 
Community Events
168
Community Groups

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

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:

 

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

Thanks.

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.

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

Thanks @Eduardo Alvarenga this worked a treat. Thanks!

Thank you @Conor O_Higgins

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

Regards,

Eduardo Alvarenga
Atlassian Support APAC

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events