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 for Metadata logs.

Any hints for the same ?

Regards and Thanks

Darpan Bhansali

 
 
 
Workflow
  • NicoleBruno's avatar
    NicoleBruno
    Valued Contributor
    3 years ago

    Hi Darpan,
    I don’t know off the top of my head but have you tried sending in a support ticket? They might be able to answer you much quicker than us.

    • darpan13's avatar
      darpan13
      Contributor
      3 years ago

      Hi Nicole,

      Thanks for the response, i had already communicated with One Stream support, seems the same request is already in queue from other customers as well and they will be releasing the same in next version release, may be by early 2021.

      but i hope my question above was clear… is there any tables which we can use and find out the workflow rename audit…

      Regards

      Darpan Bhansali

  • AndyR's avatar
    AndyR
    New Contributor III
    3 years ago

    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.