If you have already used Audtining in Dynamics CRM, you may have noticed that you cannot export logs. This is an issue I have been facing recently when I was asked how we can perform stats and measure CRM’s use.

Fortunately, there are two ways to get that logs on an Excel file. The first method that we wont use is to query AuditBase SQL table. The second one, much easier, is to use an amazing tool : MSCRM ToolKit that you can download here http://mscrmtoolkit.codeplex.com/

Here’s how:

Once you’ve downloaded the tool, extract the zip package and launch MSCRMToolKit.exe and go to Connections Manager to enter your CRM connection information

Once connected, you can go to Tools–>Audit Export Manager

Now you can filter data you want to export, click save and then run Profile

.