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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

how to export audit summary view records on dynamics365

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Arun Vinoth Profile Picture
    11,615 Moderator on at

    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

  • Verified answer
    gdas Profile Picture
    50,091 Moderator on at

    Hi Ahmad,

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

    www.xrmtoolbox.com/.../AuditHistoryExtractor

  • Ahmad Saud Profile Picture
    790 on at

    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,

  • Tony Woodhouse Profile Picture
    20 on at

    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.

  • Tony Woodhouse Profile Picture
    20 on at

    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.

  • Ahmad Saud Profile Picture
    790 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans