powercenter repository queries
–Get list of all workflows that have run since date select distinct REP_WORKFLOWS.SUBJECT_AREA, REP_WORKFLOWS.WORKFLOW_NAME from dbo.REP_WORKFLOWS join dbo.REP_WFLOW_RUN on REP_WORKFLOWS.WORKFLOW_ID = REP_WFLOW_RUN.WORKFLOW_ID where REP_WFLOW_RUN.END_TIME > ‘date’ order by REP_WORKFLOWS.SUBJECT_AREA asc, REP_WORKFLOWS.WORKFLOW_NAME asc; –Get list of on demand workflows that have run since date select distinct REP_WORKFLOWS.SUBJECT_AREA, REP_WORKFLOWS.WORKFLOW_NAME, REP_WFLOW_RUN.USER_NAME from dbo.REP...