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
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?
CRM user Interface does not provide any options to download audit report . So custom program is the only way to do so.
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.
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.
You need to download new SDK's For Dynamics 365.
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.
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?
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"
Here's a description of the SQL Connection in Excel in this blog HERE
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156