web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Change Account Ownership Log

(0) ShareShare
ReportReport
Posted on by

Hi, everyone!  Hopefully, my question makes sense to you.

We are current trying to tracking account ownership change.  Does CRM has ability track account ownership change?

For example, let say we have CRM account called 'ABC Corp.'  This account is currently owned by Sales Rep 'Joe'.

Few months after, the same account is now assigned to a new sales rep 'David'.

What we like to do is, we would like to extract data from the change log, and create Account ownership change repot with date time stamp like this:

Account  - Rep  - Last Assigned Date (Updated Date)

ABC Corp - Rep: Joe - 1/1/2016

ABC Corp - Rep: David - 6/1/2016

We've consulted our developer, but our CRM developer told us that this is not possible, and it is impossible to track specific field value change. We do have last updated date to track the last change, but this is for 'ANY' field value change in Account entity, and we can not filter the change log based on specific field (or ownership of the account).  Is this true? I went over the Microsoft document and it specifically says:

According to our developer, CRM does have 'last updated date' field to track the last change, but this is for 'ANY' field value change in Account entity. we can not filter the change log based on specific field (or ownership of the account).  Is this true? I went over the Microsoft document and it specifically says:

It is not possible to filter the change log based on specific field or track specific field change value with the time stamp (in our case ownership change of the account).  Is this true? I went over the Microsoft document and it specifically says:

The Microsoft Dynamics CRM auditing feature logs changes that are made to customer records and user access so you can review the activity later. The auditing feature is designed to meet the auditing, compliance, security, and governance policies of many regulated enterprises.

 The audit logs help the Microsoft Dynamics CRM Administrator answer questions such as:

  • Which user was accessing the system and when?
  • Who updated this field value on this record and when?
  • What was the previous field value before it was updated?
  • What actions has this user taken recently?
  • Who deleted this record?
  • What locale was used to make the update?

The following operations can be audited:

  • Create, update, deactivate, and delete operations on records.
  • Changes to the sharing privileges of a record.
  • The N:N association or disassociation of records.
  • Changes to security roles.
  • Audit changes at the entity, attribute, and organization level. For example, enabling audit on an entity.
  • Deletion of audit logs.
  • For changes made to entity fields that can be localized, such as the Product entity name or description fields, the locale ID (LCID) appears in the audit record.

https://technet.microsoft.com/library/dn887214.aspx#BKMK_viewAuditlogs

what are we missing here??

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Saroj Das Profile Picture
    3,355 on at

    Do you want to retrieve the data change history of the audited entity? Please follow the below article.

    msdn.microsoft.com/.../gg309735.aspx

    Thanks,

    Saroj

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi,

    Saroj's link is correct, you can audit all sorts of things if you write enough code.
    Can I suggest an alternative that puts the audit back into the hands of the administrator, rather than the developer? It is not difficult and provides huge benefits and flexibility.

    1212.audit.png

    We found the CRM audit process a little difficult to work with and only wanted to audit a few simple things so we simply created our own CustomAudit entity. This is an Activity type entity so it automatically has a lot of the fields we need, such as a Regarding field.
    Then we added the following fields

    • Field (name of field being changed)
    • Old Value (original value)
    • New Value (new value)
    • Updated by (Person changing the value)

    So all we have to do is create workflows (or plug-ins) that run on a specific change, like Account ownership.

    In your example, the workflow would run when the Owner field of an Account receives an update.
    The workflow creates a new CustomAudit record and populates it

    • Field = "Owner"
    • New Value = Name of new owner
    • Regarding = The Account record
    • Updated By = Person who changed the ownership

    CRM fills in the created date etc.

    You then have a list of records that can be easily viewed in CRM (with the appropriate security role). This makes it quire easy to report on, as the CustomAudit records can be liked to other attributes of the Account (or whatever entity is being audited) by the Regarding field.

    There is a little more complexity involved when you want to capture the Value From, i.e. the value that the field contained before it was changed. In this case you need to use a plug-in to capture that value. Your developer should be able to do that for you.

    I hope this provides some inspiration. Please let me know if you would like further information.

  • Community Member Profile Picture
    on at

    I think we found a solution!

    Thank you both for your quick and kind response!

  • Cheeta Profile Picture
    40 on at

    Hello Black Garlic,

    Did you end up following Brad's suggestion for the solution ? Care to share what was the solution ?

    Cheers !

  • Bhavusuresh Profile Picture
    5 on at

    Did you all find any solution.  We have similar issue in our organisation.  We dont want to write CODE. is there any readymade way

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans