Release Automation

Expand all | Collapse all

Find all deployment plans using a process in their steps

Jump to Best Answer
  • 1.  Find all deployment plans using a process in their steps

    Posted 04-27-2018 04:21 PM

    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



  • 2.  Re: Find all deployment plans using a process in their steps
    Best Answer

    Posted 05-03-2018 09:41 AM

    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



  • 3.  Re: Find all deployment plans using a process in their steps

    Broadcom Employee
    Posted 05-10-2018 10:50 PM

    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