Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Get changedate of an attribute

Posted on by

Hi All,

I would like to create an sort of automated changelog tool. What i would like to do is to determine if an field(attribute) within an entity has been changed/updated in an specific timeslot.

I noticed that using the metadata cache this information is not available and therefore I'm unable to get all changes.

I know that via the metadata cache i'm able to get the introducedversion param, but that won't give me the date/time of an changed field.

Does anyone has an clever idea on how to determine if an attribute has been changed in c#?

*This post is locked for comments

  • Alagunellaikumar Profile Picture
    Alagunellaikumar 6,210 on at
    RE: Get changedate of an attribute

    Hi Tim
    To implement it, could you give please share more detail for this implementation?

  • RE: Get changedate of an attribute

    Hi Joe. Thanks for your reply. I'm talking about customizations not value changes and therefore i think i't impossible to use the audit log

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: Get changedate of an attribute

    You can achieve this OOB, with Auditing feature. Why do you want to use a custom code?

    How many fields in a form, you want to track?

  • Tim Dutcher Profile Picture
    Tim Dutcher 2,100 on at
    RE: Get changedate of an attribute

    At Altriva, we wrote a tool (a scheduled Azure WebJob) that exports CRM entities, fields, views, workflows, etc. to CSV files and to SQL Server tables. We then run a diff on the exported data to identify new/updated parts of CRM. This also allows for sending out summary emails with CRM changes for the day or week.

    We're not a product company, so this is something that we use internally. I'm mentioning it to provide another idea if someone wants to use the same approach.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Get changedate of an attribute

    CRM does not keep any useful auditing information on CRM metadata. The only approach I can think of is that you could write a scheduled process to periodically export a solution using the ExportSolution message. You could then have another process that unzipped the solution, and compared the attribute metadata in the customization.xml file.

    And/or you could vote for Microsoft to provide metadata auditing

  • Joe Gill Profile Picture
    Joe Gill on at
    RE: Get changedate of an attribute

    Hi Maarten,

    Is there a reason you are not using auditing? maybe it does not give you what you want

    https://msdn.microsoft.com/en-us/library/gg309735.aspx

    Joe

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans