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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer Service forum / Export user access dat...
Customer Service forum

Export user access data from Audit Summary to Excel

(0) ShareShare
ReportReport
Posted on by Tony Woodhouse 20

Like many other people before me, I need to export the user access data from the Audit Summary to Excel.  I've spent hours researching this and have not found an easy answer.  Does anyone know of a 3rd Party tool which I can download and use for this purpose please?  I'm even willing to pay for it!  So far I have discovered the following:-

* You cannot do this through the CRM UI

* There was a 3rd party tool called CRM Toolbox on GitHub which had a tool for this, but it is no longer available

* There are several Audit tools in XRM Toolbox, but I've tried them all and they only work for exporting entity create / update / delete events, not user access events

* People mention there is a tool in the CRM SDK, but the latest CRM SDK CoreTools Nuget (which includes svcutil.exe etc.) does not contain an audit export tool

* It is possible to build an application to do this through the CRM SDK and there is example code on MSDN.  This is not a solution for me as I don't have the skills to do this or the time to devote to it unfortunately.

If anyone can provide a nice simple web-link to a Windows executable I can just run and use I would be eternally grateful! :-)

Thanks,

Tony

Categories:
Security and Privacy
I have the same question (0)
  • LeoAlt Profile Picture
    LeoAlt 16,331 Moderator on at

    Hi partner,

    If you mean you want to find the logs of user access and export them to excel ,you could go to  https://protection.office.com>Search> Audit log search and configure the filter to find the audit records. The audit here records the User access record, the user actions and even who changed password.

    And it also support exporting to excel.

    community320.png

    https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/enable-use-comprehensive-auditing

    Hope it helps.

    Best Regards,

    Leo

  • Tony Woodhouse Profile Picture
    Tony Woodhouse 20 on at

    Hi, sorry, I should have made it more clear that my question relates specifically to Dynamics CRM.  I use an IFD deployment of CRM 2016 but I believe nothing had changed in this respect to Dynamics CRM online.  Your answer sadly doesn't help me. Thanks though.

  • LeoAlt Profile Picture
    LeoAlt 16,331 Moderator on at

    Hi partner,

    Thanks for your reminder and supplement.

    1.If you are using on-premise instance, you could get the user access log from Data Base directly with the following sql code.

     select us.FullName, max(a.CreatedOn) as LastLoginDate from Audit a

 inner join SystemUser us on a.ObjectId = us.SystemUserId

 where

 a.Operation = 4 and us.IsDisabled = 0

 group by us.FullName


    2.If you are using online instance, you could use XML to query user access data and then create a SSRS report with this data.

       https://www.concurrency.com/blog/march-2016/creating-an-audit-report-for-user-logins-in-dynami

    3.You could also develop a C# application to export the auditing logs.

    https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg309735(v=crm.8)

    Hope it helps.

    Best Regards,

    Leo





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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans