Dynamics CRM - Possible values for TraceLogBase.ErrorTypeDisplay

In my current project we are cleaning up the TraceLogBase table to reduce the DB size and overall get rid of unnecessary data.

Since the documentation on MSDN is not very helpful to understand/make sure what exactly is traced in the table (only email related or other things as well), I extracted the current entries of a ~3 years old database and grouped them by "ErrorTypeDisplay". Following values I identified.

Note: Maybe not complete!

• ExchangeSyncACTDeliveryMethodNotExchangeSynchronization
• ExchangeSyncUnapprovedEmailAddress
• IncomingDeliveryMethodNotEmailRouter
• IncomingEmailRejected
• IncomingEmailServerServiceError
• IncomingMailboxTimeoutError
• IncomingServerCertificateError
• IncomingTestConfigurationSuccess
• InvalidIncomingEmailServerProfile
• InvalidIncomingMailboxCredentials
• InvalidIncomingMailboxEmailAddress
• InvalidOutgoingEmailServerProfile
• InvalidOutgoingMailboxCredentials
• InvalidRecipientEmailAddress
• MailboxQuotaExceeded
• OutgoingDeliveryMethodNotEmailRouter
• OutgoingEmailServerServiceError
• OutgoingMailboxSendAsPermission
• OutgoingServerCertificateError
• OutgoingTestConfigurationSuccess
• RetrieveAttachmentFailure
• UnapprovedIncomingEmailAddress
• UnapprovedOutgoingEmailAddress

Query which also returns the amount of traces

Use

SELECT ErrorTypeDisplay, Count(*) AS 'Number of Traces'

FROM

GROUP BY ErrorTypeDisplay

ORDER BY ErrorTypeDisplay

Cheers

Dynamics CRM TimeZones

To retrieve timezone records for Dynamics CRM you can use following request.

IOrganizationService service = con.GetOrganizationService();
QueryExpression query = new QueryExpression("timezonedefinition");
query.ColumnSet = new ColumnSet(true);
EntityCollection col = service.RetrieveMultiple(query);

You can find a list (exported from 2016 online) here:

• CSV
• Excel

Cheers

Online toolbox "msxrmtools.com"

Today i found a nice little helper. It provides metadata browser, FetchXML tester, Url QueryString Analyzer and other helpful features. And all of that without importing solutions to your organization or running local applications.

msxrmtools

Fetch XML sample

QueryString analyzer sample

Cheers

Dynamics CRM – Get rid of warning messages for Outlook, Navigation Tour and Tablets

The messages are pretty helpful for the first time you are using the system. But especially if you have to prepare demo environments very often, you don’t want to have them anytime logging in to your environment.

Disable “Outlook Client” – Message

Settings –> Administration –> Outlook-Tab –> Disable “Users see ‘Get CRM for Outlook’ option displayed in the message bar”

 

Disable “Navigation Tour” – Message

Settings –> Administration –> General-Tab –> Disable “Display navigation tour to users when they sign in”

 

Disable “Tablet” – Message

Settings –> Administration –> General-Tab –> Disable “User see app download message”

 

Cheers