Deployment Group History report

Displays, by group, deployment groups and the dates they were deployed. It also displays the source and target repository names of the deployment group for all deployment dates. This is a primary report in an analytic workflow.


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


select "DEP_GROUP_NAME",
"DESCRIPTION",
"REPOSITORY_NAME",
"CREATED_BY",
case when ("GROUP_TYPE" = 0) then ('Normal') else (case when ("GROUP_TYPE" = 1) then ('Dynamic') else ('') end) end as "Calc_GROUP_TYPE",
"TARGET_REP_NAME",
"USER_NAME",
"DEPLOY_TIME"
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"

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*