Documentum getting list of workflow performers

Below queries can be used to get the details about

• What happend during a wrokflow
• Which user performed which task
• How long a task was waiting to be processed e.t.c.

1. Use the below query to get the process ids related to your templete

            select * from dm_process where object_name like '%DBP%';

 

2. Use the Below query to get  the completed workflow ids related to a process id

select * from dmc_completed_workflow where process_id = 'my_process_id';

 3. Use the below query to get the information related to a completed workflow

select * from dmc_completed_workitem where workflow_id in (select workflow_id from dmc_completed_workflow where process_id = 'my_process_id' )

order by workflow_id, act_seqno;