Bamboo SQL Query to list all the disabled plans

Question

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

Thanks in Advance

Foong · Answer

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

Gonchik Tsymzhitov · Answer

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