Users participated in a workflow

buddyt
buddyt Member
edited May 22, 2012 in Documentum #1

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.

Tagged:

Comments

  • DCTM_Guru
    DCTM_Guru Member
    edited May 21, 2012 #2

    You can query for this in the audit trail IF you enable workflow auditing beforehand.  Otherwise, this information is no longer available to you.

  • buddyt
    buddyt Member
    edited May 21, 2012 #3

    That's what I thought too, as we purge audit log every 3-week. Thanks for the quick reply!

  • bacham2
    bacham2 Member
    edited May 22, 2012 #4

    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.

  • buddyt
    buddyt Member
    edited May 22, 2012 #5

    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?

  • bacham2
    bacham2 Member
    edited May 22, 2012 #6

    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.

  • buddyt
    buddyt Member
    edited May 22, 2012 #7

    We don't have the BPM suite and that explain why I can't find it.

    Thanks for your help!

  • regisroy
    regisroy Member
    edited May 22, 2012 #8

    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

Categories