Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Audit CRUD functionality
Microsoft Dynamics 365 | Integration, Dataverse...
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

  • 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,056 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

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans