Bamboo SQL Query to list all the disabled plans

[swathi K]

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

Thanks in Advance

[Foong]

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]

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