Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Bamboo SQL Query to list all the disabled plans

swathi K June 18, 2018

I'm looking out for an SQL Query which can find out all the disabled plans in bamboo.

 

Thanks in Advance

2 answers

1 vote
Foong
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 18, 2018
SELECT * FROM BUILD
WHERE SUSPENDED_FROM_BUILDING = TRUE
AND BUILD_TYPE IN ('CHAIN','CHAIN_BRANCH')
ORDER BY FULL_KEY;

CHAIN is main plan while CHAIN_BRANCH is branch plan 

0 votes
Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 18, 2018

Hi! 

 

May I know what is the your purpose? 

I have met sometimes with issues releated for cleaning disabled plans. 

I am using this rest api https://github.com/AstroMatt/atlassian-python-api/pull/47/commits, or you can use this script https://gist.github.com/sguillope/001c1f5574be3be3a595

Also, keep in your mind this sql queries for fetch disabled

https://confluence.atlassian.com/bamkb/how-to-query-plan-branch-details-from-the-bamboo-database-867032636.html

 

Cheers,

Gonchik Tsymzhitov

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events