Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

how to export audit summary view records on dynamics365

Posted on by 790

dear all


i need a way to export the records in the Audit summary view, i tried using

mscrmtoolkit, but it seems it does not connect to dynamics365. any idea ?

thanks,

*This post is locked for comments

  • Ahmad Saud Profile Picture
    Ahmad Saud 790 on at
    RE: how to export audit summary view records on dynamics365

    thanks a lot.

    but this tool can't export anything beyond 5000 records, it is limited to 5000 records.

    so i used SSIS to extract a full copy of the Audit table into my local SQLServer DB , then i did all the queries i needed.

  • Tony Woodhouse Profile Picture
    Tony Woodhouse 20 on at
    RE: how to export audit summary view records on dynamics365

    Sorry - I've realised I was only partially correct before.  The tools in XRM toolbox are useful for exporting entity audit records and therefore are a good answer to the OP.  However, my problem is that I need to export user access audit logs, and the tools are not helpful for that purpose.

  • Tony Woodhouse Profile Picture
    Tony Woodhouse 20 on at
    RE: how to export audit summary view records on dynamics365

    There are three plugins currently available in XRM Toolbox for export Audit records, and non of them allow export of user access audit data.  They are all aimed at exporting record update / create / delete events on entity records.  This answer does not help, sorry.

  • Ahmad Saud Profile Picture
    Ahmad Saud 790 on at
    RE: how to export audit summary view records on dynamics365

    correct, i just used it an hour ago and it is fine, the main issue with this tool is that the maximum records to extract are 5000, but it helped me even with this limitation.

    thanks,

  • Verified answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: how to export audit summary view records on dynamics365

    Hi Ahmad,

    I have not tried yet seems it's there in XRMToolbox.

    www.xrmtoolbox.com/.../AuditHistoryExtractor

  • Suggested answer
    Arun Vinoth Profile Picture
    Arun Vinoth 11,613 on at
    RE: how to export audit summary view records on dynamics365

    This was discussed earlier here: community.dynamics.com/.../243239

    Have you tried Audit export manager? This may also break as there are changes in CRM connection recently.

    dynamicscrmcoe.com/export-audit-logs

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

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