locked
To check who approved each change set. RRS feed

  • Question

  • Hi All

    We were able to explore the approval functionality and it is working very well. 

    We have one question. Kindly suggest how we can identify who approved the changes. This is required for audit purpose. 

    Thanks,

    Nagendra.S

    Wednesday, March 15, 2017 9:40 AM

All replies

  • Hello,

    This is new feature in mssql 2016.

    https://www.mssqltips.com/sqlservertip/4289/approval-workflow-in-sql-server-master-data-services-2016-using-change-sets--part-1/


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Saturday, March 18, 2017 3:49 PM
    Answerer
  • Hi Vishe,

    Thanks for the reply. We were able to get his flow. 

    Now as per our client audit process, we should know who (which user) approved/rejected each change set. This information we are not able to get anywhere in the system. Once the change set is approved the UI only shows the status as Approved it doesn't show who approved this change. 

    It will be of great help if you can proved this answer. 

    Thanks,

    Nagendra.S 

     
    Thursday, March 23, 2017 5:32 AM