Deployment Details report

Displays, by group name, type, and creator, the details of the deployed objects by a particular deployment group. This report is the first node in the analytic workflow associated with the Deployment Group History primary report.

Click on the text to copy the query report to your clipboard.


select "DEP_GROUP_NAME",
"REPOSITORY_NAME",
"CREATED_BY",
case when ("IS_SHORTCUT" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT",
"OBJECT_TYPE_NAME",
case when ("GROUP_TYPE" = 0) then ('Normal') else (case when ("GROUP_TYPE" = 1) then ('Dynamic') else ('') end) end as "Calc_GROUP_TYPE",
"TARG_SUBJECT_AREA",
"OBJECT_NAME",
"SRC_VERSION_NUMBER",
"TARGET_REP_NAME",
"SRC_SUBJECT_AREA",
"DEPLOY_TIME",
"TARG_VERSION_NUMBER"
from (SELECT  DISTINCT DEPLOYMENT_GROUP.DEP_GROUP_NAME,     DEPLOYMENT_GROUP.GROUP_TYPE as GROUP_TYPE,  DEPLOYMENT_GROUP.CREATED_BY,  DEPLOYMENT_GROUP_DETAIL.DEPLOY_TIME,  DEPLOYMENT_REPOSIT_INFO.REPOSITORY_NAME,  DEPLOYMENT_GROUP_DETAIL.TARGET_REP_NAME,  DEPLOYMENT_GROUP_DETAIL.OBJECT_NAME,  DEPLOYMENT_GROUP_DETAIL.OBJECT_TYPE_NAME,  DEPLOYMENT_GROUP_DETAIL.SRC_VERSION_NUMBER,  DEPLOYMENT_GROUP_DETAIL.TARG_VERSION_NUMBER,  DEPLOYMENT_GROUP_DETAIL.SRC_SUBJECT_AREA,  DEPLOYMENT_GROUP_DETAIL.TARG_SUBJECT_AREA,    DEPLOYMENT_GROUP_DETAIL.IS_SHORTCUT as IS_SHORTCUT,    DEPLOYMENT_GROUP.DESCRIPTION as DESCRIPTION,    DEPLOYMENT_GROUP_DETAIL.USER_NAME    FROM  REP_REPOSIT_INFO DEPLOYMENT_REPOSIT_INFO,  REP_DEPLOY_GROUP DEPLOYMENT_GROUP    LEFT OUTER JOIN REP_DEPLOY_GROUP_DETAIL DEPLOYMENT_GROUP_DETAIL    ON DEPLOYMENT_GROUP.DEP_GROUP_ID = DEPLOYMENT_GROUP_DETAIL.DEP_GROUP_ID  WHERE  (DEPLOYMENT_GROUP.DEP_GROUP_ID <> DEPLOYMENT_REPOSIT_INFO.REPOSITORY_ID)) "query"
order by "DEP_GROUP_NAME", "Calc_GROUP_TYPE", "CREATED_BY"