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_WORKFLOWS
join dbo.REP_WFLOW_RUN
on REP_WORKFLOWS.WORKFLOW_ID = REP_WFLOW_RUN.WORKFLOW_ID
where REP_WFLOW_RUN.END_TIME > ‘date’ and REP_WFLOW_RUN.RUN_TYPE = 2
order by REP_WORKFLOWS.SUBJECT_AREA asc, REP_WORKFLOWS.WORKFLOW_NAME asc;