Find all deployment plans using a process in their steps

[Legacy User]

Hi,

 

I'm trying write a DB query to find all the deployment plan using a particular process as one of the deployment steps.

 

Anyone has already figured that out ?

 

Merci

[Michael Gebhardt]

Hi,

 

we're using this query to get all the plans to a given process and process tag:

 

select
 rcdt.name as TemplateName
 ,rcrc.ID as PlanID
 ,rcrc.name as PlanName
 ,rcrc.build as PlanVersion
 ,c.PROCESS_NAME as ProcessName
 ,s.TAG_NAME as ProcessTag
from
 rc_release_candidate as rcrc
 inner join rc_rc_module rcrcm
  on rcrcm.release_candidate_id=rcrc.id
 inner join rc_basic_modules rcbm
  on rcbm.id=rcrcm.id
 inner join published_process s
  on s.ID=rcbm.published_process
 inner join process_container c
  on c.ID=s.ID
 inner join rc_deploy_template rcdt
  on rcrc.deployment_template = rcdt.id
where c.PROCESS_NAME like 'Predeployment'  AND s.TAG_NAME like '1.3'
Order by TemplateName,PlanID Desc

 

best regards

Michael

[Yasuyuki Miura]

Hi,

 

Did Michael's reply answer your question?

If it did, please click "Mark Correct" on the reply. If you need additional help, please let us know.

 

Thanks in advance.

Yas