Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / Audit CRUD functionality
Dynamics 365 general forum
Answered

Audit CRUD functionality

(0) ShareShare
ReportReport
Posted on by Martin Andersson 40

Hi all,

I need to audit CRUD in Dynamics. If a customer comes to us and ask us if anyone have seen or worked (updated, created, deleted information) with their information, I need to be able to tell them. I need to be able to, for example from a contact or account, extract information about if someone have been Created, Read, Updated or Deleted information regarding that account or that customer.

What´s the best approach here? Third party? API to extract data from Compliance center? Something else? This must have been done before ;)

Kind regards

Martin

Categories:
Dynamics 365 Administration
Applications and Add-ons
Other Functionality
Integration with Other Products
Customization / Solutions / SDK and API
  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    RE: Audit CRUD functionality

    Hey Martin.

    On this post https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/402019/audit-data-export Audit Export from XrmToolbox is shown, as well as the Compliance center.  IN Find the right app | Microsoft AppSource, if you search for "Audit" and filter by Dynamics 365 CRM products, there are several other offers from MindTree and Zap Objects

    In all cases, they will require that you enable auditing on the environment and verify the tables/objects being audited.

    Regards

  • Martin Andersson Profile Picture
    Martin Andersson 40 on at
    RE: Audit CRUD functionality

    Hi Daniel,

    I have done what Nya posted and tried Compliance Center, but its search is very limited.

    Do you have any examples of third party tools? The link is also very interesting, but using database instead of Excel :)

  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    RE: Audit CRUD functionality

    Hey Martin.

    The first thing to get this data is what Nya has posted: you need to enable auditing on the entities that are part of your requirement.  Without this, information is not going to be stored.

    Once this is done, there are several ways you can check the auditing data:

    a. You can always use third party tools.

    b. You can use the Compliance Center data, as indicated on docs.microsoft.com/.../enable-use-comprehensive-auditing

    c. You can grab the data from Compliance Center, export it to excel and use PowerBI.  There's a nice example on mscrmonline.wordpress.com/.../

    Best regards,

  • Martin Andersson Profile Picture
    Martin Andersson 40 on at
    RE: Audit CRUD functionality

    Hi,

    I have. I might be wrong, but I cant see any possibility to achieve the functionality described in my question.

  • Suggested answer
    Nya Profile Picture
    Nya 29,054 on at
    RE: Audit CRUD functionality

    Hi Martin,

    Please refer to the following documentation.

    Audit data and user activity for security and compliance - Power Platform | Microsoft Docs

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans