locked
Old and new values RRS feed

  • Question

  • I am performing auditing on X entity and when a field is updated I need to record the old and new value. 

    So far I've not been able to record old value.

    KV
    Thursday, November 26, 2009 12:02 PM

Answers

  • Hi.

    You can use Pre-Update images. I've developed similar functionality. You can see and download it here .
    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Thursday, November 26, 2009 12:13 PM
    Moderator
  • You can also try using Microsoft CRM's Accelerators like "Business Data Auditing"

    http://crmaccelerators.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=27404

    " The Business Data Auditing Accelerator provides basic audit capabilities for organizations using Microsoft Dynamics CRM. The accelerator takes a snapshot of a record whenever the relevant event occurs within the system such as Create, Update, Assign and Delete. Through workflow, auditing can be configured for any entity and any trigger event. "
    MS CRM MVP :: uMar Khan :: Microsoft CRM Consultant (Blog :: http://umarkhan.wordpress.com)
    Thursday, November 26, 2009 1:14 PM
    Moderator

All replies

  • Hi.

    You can use Pre-Update images. I've developed similar functionality. You can see and download it here .
    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Thursday, November 26, 2009 12:13 PM
    Moderator
  • You can also try using Microsoft CRM's Accelerators like "Business Data Auditing"

    http://crmaccelerators.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=27404

    " The Business Data Auditing Accelerator provides basic audit capabilities for organizations using Microsoft Dynamics CRM. The accelerator takes a snapshot of a record whenever the relevant event occurs within the system such as Create, Update, Assign and Delete. Through workflow, auditing can be configured for any entity and any trigger event. "
    MS CRM MVP :: uMar Khan :: Microsoft CRM Consultant (Blog :: http://umarkhan.wordpress.com)
    Thursday, November 26, 2009 1:14 PM
    Moderator
  • As mentioned you can do it with code and the codeplex audit tools. The other option is an attribute to store the old value. Have it populate on the creation of the record and then have your audit workflow extract the two values and then copy the new value to the old value attribute afterwards.

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet @leontribe
    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Friday, November 27, 2009 8:08 AM
    Friday, November 27, 2009 8:08 AM