Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Audit Summary data export to Excel

(0) ShareShare
ReportReport
Posted on by

I need to produce some analytics from the Audit Summary data in MS Dynamics CRM 2015, Anyone have a solution to extract the data to Excel to do this?

*This post is locked for comments

  • Suggested answer
    Nishant Rana Profile Picture
    Nishant Rana 11,314 Microsoft Employee on at
    RE: Audit Summary data export to Excel

    This might help

    nishantrana.me/.../

  • JRas Profile Picture
    JRas 25 on at
    RE: Audit Summary data export to Excel

    Chirag - You've missed the point of this thread.  That is what we are saying - this NEEDS to be in the GUI and not require a custom program.  Dinesh's earlier response: "In CRM through GUI you won't be able to export audit logs in Excel.  This by design." is the crux of the problem.  Why on earth would they bother to give us only half a tool?  This "by design" is flawed - or is it their plan to have us keep buying licenses that we don't actually need?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Audit Summary data export to Excel

    CRM user Interface does not provide any options to download audit report . So custom program is the only way to do so.

  • JRas Profile Picture
    JRas 25 on at
    RE: Audit Summary data export to Excel

    How is loading SDKs going to help?  I looked at that link and saw nothing that looked like a solution to this issue?  Even if one of the SDKs has an API for accessing audit info, that still requires a custom program/script to perform what should have been in the GUI all along.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Audit Summary data export to Excel

    Yes 100% agree, as this seems to be the only way to audit for license justification. Did you manage to resolve this, as i find myself at the same quagmire.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Audit Summary data export to Excel

    You need to download new SDK's For Dynamics 365.

    docs.microsoft.com/.../download-tools-nuget

  • JRas Profile Picture
    JRas 25 on at
    RE: Audit Summary data export to Excel

    Why would this be done on purpose?  The summary view is so limited as to be nearly useless.  I'm trying to find out who is making use of their licenses, and being able to dump an audit log for user logins would be useful.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Audit Summary data export to Excel

    The MSCRM ToolKit worked until we were updated to Dynamics 365. Now it says Error: Metadata contains a reference that cannot be resolved.

    Are there any other tools available that can export the Audit log?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Audit Summary data export to Excel

    Hello Helen,

    In CRM through GUI you won't be able to export audit logs in Excel.

    This by design.

    Regards,

    Dinesh 

    Microsoft Dynamicsâ„¢ CRM Support Engineer

    "Please mark my answer as verified if you found it helpful"

  • Suggested answer
    NicksTuk Profile Picture
    NicksTuk 1,833 on at
    RE: Audit Summary data export to Excel

    Here's a description of the SQL Connection in Excel in this blog HERE

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans