Release Automation

  • 1.  How to get report which contain approval activity?

    Posted Apr 09, 2015 07:41 PM

    I couldnt seems able to find reporting which include the approval gate activity (ie: who approve the manual approval). This is important during audit.

     

    Whilst it's possible to go into each deployment to view, it's not possible to get a consolidated report for this..

     

    Anyone has the workaround?



  • 2.  Re: How to get report which contain approval activity?
    Best Answer

    Posted Apr 18, 2015 09:21 AM

    One way to get manual approval detailed will be by directly query the DB

    e.g

     

    SELECT re.id as ReleaseID ,re.name as Release_Name , ma.status,ma.username, ma.deny_reason FROM nolio_db55.rc_manual_approval ma

    inner join rc_releases re on re.manual_approval_gate=ma.id

    order by ma.id desc

    limit 20;

     

    approval.png

     

    Jacky