Forum Discussion

darpan13's avatar
darpan13
Contributor
3 years ago

Audit Log for Workflow Profile Rename or move under different Parent

SOURCE: ONESTREAM CHAMPIONS Hi Team, i was looking for the Audit Log for Workflow profile re-name or workflow profile movement from one parent to another, almost similar to what we have...
Workflow
AndyR's avatar
AndyR
New Contributor III

Hi Darpan,
Based on your question I’m guessing you have access to the System tab in OS. I believe the application table AuditWorkflowProfileHierarchy will give you the information you’re looking for. It has the ProfileName as well as the Keys for the WF Profile and the Parent. Of course there is potentially extra work needed depending on how you want to report this to other people, but I’m ignoring that for now.
Thanks,
Andy

darpan13's avatar
darpan13
Contributor
3 years ago

Many Thanks for your inputs, Based on the tables below, we were able to Frame the query to get the required data into the excel format.

  1. Profile Rename – New name and old name ( able to fetch in a row… but no code to have saying old MEP and new MEP ) – Still it Works.
  2. Parent Profile modifications are also being tracked / Audited, which we were able to derive. – Works.

Still have few questions as below.

We are not able to find Audit logs / Tables for the modifications done at Work Flow Execution Group & Certification SignOff Group. How to find the audit log for the same ? ( Refer screenshot below )

Regards

Darpan Bhansali

Screenshot%202020-11-24%20151755
Screenshot 2020-11-24 151755.jpg757×238 50.1 KB
  • NicoleBruno's avatar
    NicoleBruno
    Valued Contributor
    3 years ago

    Changes made to security on master data will show on the out of the box Metadata Audit reports dashboards (in the XFS Metadata Audit dashboards maintenance unit) and it looks like they’re pulling from the data base tables AuditMember and AuditRelationship.

    • darpan13's avatar
      darpan13
      Contributor
      3 years ago

      Agreed Nicole,

      But Those reports are primarily for Metadata Changes ( Dimension Changes )

      Work Flow Profile changes are not included in those reports.

      Regards

      Darpan

      • NicoleBruno's avatar
        NicoleBruno
        Valued Contributor
        3 years ago

        Hi Darpan,
        You’re right - the screenshot looked like a master data section.

  • LeeB's avatar
    LeeB
    Contributor II
    3 years ago

    Hi Darpan,

    See the latest version of the Standard Application Reports available in the Marketplace (PV610 SV100).

    There is a new Workflow Profile Audit report group which contains the following reports:

    • Workflow Profile Audit – Added: Shows the workflow profile group and/or workflow profile properties added within a specified date range and the user who added them.
    • Workflow Profile Audit – Updated: Shows the workflow profile group and/or workflow profile properties updated within a specified date range and the user who updated them.
    • Workflow Profile Audit – Deleted: Shows the workflow profile group and/or workflow profile properties deleted within a specified date range and the user who updated them.

    Lee