Audit & Telemetry in MS DYNAMICS CRM

Question

Is there any possible way to get advanced auditing options in crm dynamics (third party tool, querying database filteredviews)

I want to know Number of user connected, duration of connection for each user, time passed in each form, reports executed(by who).

Yes, there is auditing in CRM. Check this article: https://community.dynamics.com/crm/b/crmlessons/archive/2011/03/29/crm-2011-auditing-best-practices If it is on premise and you can query SQL you have those tools at your disposal as well. — Jacob H, Jun 16 '17 at 15:11
If you want this level of detail, you probably need tracking like Google Analytics. — Filburt, Jun 16 '17 at 15:11

Arun Vinoth-Precog Tech - MVP · Accepted Answer · 2017-07-27T18:14:41.370

0

You have asked for 2 different things.

Auditing:

CRM OOB auditing data stored in on-premise SQL is "," and "~" separated, so have to do reverse engineering & some Power BI chart will visualize nicely on top of the data. We did that by referring below link.
https://marcuscrast.wordpress.com/2012/01/14/dynamics-crm-2011-audit-report-in-ssrs/

Telemetry:

Custom solution using application insights can be collected, including your own metrics like explained in my blog post below.
https://learn.microsoft.com/en-us/azure/application-insights/app-insights-sample-mscrm

On a side note, CRM 2016 has a preview feature of Organization Insights which will cover few of your asks. Refer the link below.
https://technet.microsoft.com/en-us/library/mt703628.aspx

edited Jul 27 '17 at 18:14

answered Jun 16 '17 at 18:05

For 3rd party tools, search the internet. – Arun Vinoth-Precog Tech - MVP Jun 16 '17 at 18:08
Thank you Arun those links are very helpful..can i use the application insight for dynamics 2015 on premise? – fnando Jun 17 '17 at 03:34
Yes, you need Azure subscription & internet access (why am saying this - banking domain will not have) – Arun Vinoth-Precog Tech - MVP Jun 17 '17 at 03:39

1 Answers1