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 ?
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 ProcessTagfrom 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.idwhere c.PROCESS_NAME like 'Predeployment' AND s.TAG_NAME like '1.3'Order by TemplateName,PlanID Desc
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.