My management wanted to identify everyone (users in Documentum) who has ever participated in a workflow. Is there any ways I could obtain the information via DQL? Any help on the DQL is appreciated.
You can query for this in the audit trail IF you enable workflow auditing beforehand. Otherwise, this information is no longer available to you.
That's what I thought too, as we purge audit log every 3-week. Thanks for the quick reply!
The workflow-related audit trail information can be consolidated into dmc_completed_workflow and dmc_completed_workitem objects but it requires that the appropriate job (something like dm_WFReporting) runs on a regular basis.
I can't find the dm_WFReporting job or method via DA.
Is it the same as saving the running or completed workflows via Workflow Reporting in Webtop?
No it's not the same. I think that the job is part of the BPM DAR. If you have licensed the BPM suite, you should have it.
We don't have the BPM suite and that explain why I can't find it.
Thanks for your help!
hi
the classes used for this job are part of Content Server. Create a method and a job
You will just need to know how they are declared when using BPM.
It seems to be a little hacky else you can write your own consolidation program
