on 04-19-2007 3:49 AM
Who can give an example to explain, how to use Change Tracking. And what's the impact on the process if we change the default setting?
Hi Alfred,
As Specified in Console reference guide:
The Change Tracking table is an MDM system table with a predefined set of fields, and records that are not directly visible in either the MDM Console or the MDM Client. Each record is created automatically by MDM when the value of any field that you are tracking is changed, providing an audit log of changes within the system.
For each change, MDM records the date, the time, the user who made the change, the old value, and the new value.
There are three type of Change Tracking Settings:
Track Adds track new field value when a record is added
Track Modifies track old and new values when the field is modified
Track Deletes track old field value when a record is deleted
Thanks and regards,
<b>Sagar Sonje.
Mark Helpful Answers</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
To track chages we are to :
1. enable change tracking in the console
2. check the corresponding <repository>_z000 table in the SQL server query for the records changed
In our case, we ave followed the steps detailed in the blog, there are a few visible differences, which are probably due to SQL server version updates. However, on executing the query we do not get any output, inspite of making changes.
Are there any other parameters to be set in SQL server ?
Thanks in advance for your suggestions,
Regards,
Anita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Ravi., I am going to take a look.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you can through this blog:
/people/balas.gorla/blog/2006/09/08/change-tracking-in-mdm
I hope this will help you.
Regards,
Ravi.
Please mark helpful answers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.