Audit Steps Action in Deployment Plan

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

When a step is added or removed in a Deployment Plan no record is logged in Audit History Report.
How to track the steps modification in a Deployment Plan ?

Environment

Release Automation 6.8.*, 6.9.*

Resolution

Actions on Steps (ADD/REMOVE) in a deployment plan are not reported into the Audit Report History.
This enhancement is currently being worked on by the development team for possible inclusion in a future release of product.

This article gives the list of actions which are recorded in Audit History Report : List of Actions recorded in Audit History Report

Actions on Deployment Plan Step are not present in this list.

As a workaround following SQL Query could be used:

SELECT
    ap.APP_NAME AS 'Application',  
    pr.name AS 'Project', 
    pl.name AS 'Deployment Plan', 
    bm.name AS 'Step Name', 
    mo.stageType AS 'Stage Type',
    pc.PROCESS_NAME AS 'Process Name', 

    CASE bm.REVTYPE
        WHEN 0 THEN 'CREATE STEP'
        WHEN 1 THEN 'UPDATE STEP'
        WHEN 2 THEN 'DELETE STEP'
    END AS 'Audit Action',
    DATEADD(SECOND, de.timestamp / 1000, CONVERT(DATETIME, '19700101')) AS 'Audit Action Date', 
    de.username AS 'Audit Action UserName'
FROM rc_release_candidate pl
INNER JOIN rc_version pr ON pr.id = pl.version
INNER JOIN applications ap ON pr.applicationId = ap.id
INNER JOIN rc_rc_module_aud mo ON mo.release_candidate_id = pl.id
INNER JOIN rc_basic_modules_aud bm ON bm.id = mo.id AND bm.REV = mo.REV
INNER JOIN process_container pc ON pc.ID = bm.published_process
INNER JOIN designrevisionentity de ON de.id = bm.REV
ORDER BY ap.APP_NAME, pr.name, pl.name, bm.REV;

Example :