Comments

1 comment

  • Avatar
    Shane Gilbert

    Here is a query that will get this information and can be used in an Analytics Report to make it more accessible.

    SELECT
      a.DATE_OCCURRED,
      a.PERFORMER,
      a.DESCRIPTION,
      p.PROC_INST_ID,
      p.DEF_NAME,
      p.APPL_NAME,
      p.PROC_INITIATOR
    FROM dbo.WF_AUDIT_TRAILS a
      JOIN dbo.WF_PROC_INSTS p ON a.OBJECT_INFO = p.PROC_INST_ID
    WHERE DESCRIPTION IS NOT NULL
      AND PURPOSE = 'CancelProcessInstance'

    0
    Comment actions Permalink

Please sign in to leave a comment.