Weekly BPM Process Execution Report – Last 7 Days

Products

• Clarity PPM SaaS

Issue/Introduction

There is need to review the processes and their instance runs in order to answer the following questions:

• What is the process code and name?
• When was the process created and by whom?
• When was the process modifed and by whom?
• When did the process run?
• Who initiated the process?
• What is the status of a process instance?
  
  
  

Environment

Any 

Resolution

Run the following SQL query against the Clarity database:

SELECT bdpv.id AS process_version_id,
bdpv.process_id AS process_id,
bdp.process_code AS process_code,
ccn.name AS process_name,
brp.id AS process_instance_id,
brp.start_date AS start_date,
brp.end_date AS end_date,
brp.percent_complete AS percent_complete,
brp.status_code AS status_code,
sr.first_name AS initiated_by_first_name,
sr.last_name AS initiated_by_last_name
FROM bpm_def_processes bdp
, bpm_def_process_versions bdpv
, bpm_run_processes brp
, srm_resources sr
, cmn_captions_nls ccn
WHERE bdp.id = bdpv.process_id
AND brp.process_version_id = bdpv.id
AND sr.user_id = brp.initiated_by
AND ccn.pk_id = bdp.id
AND ccn.table_name = 'BPM_DEF_PROCESSES'
AND ccn.language_code = 'en'
AND brp.start_date >= SYSDATE - 7
ORDER BY brp.start_date DESC

Run and export the results to discuss the results with Support.