Is it possible to query bamboo DB to get list of deployment projects with related plan?

[Aparna Kurra]

Hi,

I want to query bamboo DB to get the list of deployment projects that has linked plans.

Thanks,

Aparna.

[Eduardo Alvarenga]

Hello @Aparna Kurra

Welcome to Atlassian Community!

You can try the following query:

SELECT * FROM DEPLOYMENT_PROJECT;

You would be interested in the name, and plan_key columns.

Cheers,

Eduardo Alvarenga
Atlassian Support APAC

--please don't forget to Accept the answer if the reply is helpful--