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.
case when ("GROUP_TYPE" = 0) then ('Normal') else (case when ("GROUP_TYPE" = 1) then ('Dynamic') else ('') end) end as "Calc_GROUP_TYPE",
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"