June 7, 2016 at 3:22 am
Hi,
I was wondering if anyone had a method for auditing changes in an MDS entity member.
For example when a user modifies some data in Excel and publishes it they enter a comment. How can I access this comment and the details of what was changed to produce and audit report?
Thanks,
Nic
June 10, 2016 at 4:11 am
Hi,
I've come up with a solution to this (in part). The MDS data is synced over to another system via an SSIS package. In the package I bring over the data including the last change data and the user who made the change, I then use a MERGE to sync this staging data to the live table, I use the OUTPUT to write to an audit table.
All works, with one exception, whilst DELETE's are recorded as the data was never brought over to the staging table I can never know who deleted it in MDS.
So my question now is how do I know in MDS by whom and when was a leaf member deleted?
Thanks,
Nic
June 10, 2016 at 7:21 am
Could you create a trigger to capture deletes and insert to your audit table?
June 10, 2016 at 8:21 am
Hi,
Thanks for the reply, yes I could but I was trying to avoid that if I could but I think it may have to be that.
I just don't buy that MDS doesn't have a log somewhere of who did the delete.
Thanks again,
Nic
Update
The trigger wont actually do it for me unless I put the trigger on the MDS leaf table itself, which I'm really not keen on doing.
Putting it on the destination table will detect the delete and the delete time but not the user who did the delete in MDS, only the user the MERGE(delete) runs as.
More digging for me it seems
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply