Blog Archives

List of custom Plug-in SDK steps

How to find the list of custom plug-in SDK steps using Advance Find: Go To Advance Find: Mention below two criteria to find the list of custom plugin SDK steps Event Handler     Does Not Contain       Microsoft Name

Posted in Advance Find, CRM Query, Solution

CRM Status and Status Reason Default Value

Default status and status reason values This topic lists the default State and Status Reason values for system entities that do not use the default values shown in the following table. State Status Reason 0 : Active 1 : Active

Tagged with: , ,
Posted in CRM Internal, CRM Query

Issue with Removing Lead entity from Tablet navigation

Issue: When unchecked “Enable for mobile” option and click on “Save” getting the same error. Error from the log file: Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: You need to enable this entity for mobile before you can enable it

Tagged with: ,
Posted in CRM Error, CRM Query

Microsoft Dynamics CRM – How to find duplicate reports?

Use below query to find the duplicate reports in your Organization. SELECT name FROM Report GROUP BY name HAVING count(*)>1  

Posted in CRM Query

MS CRM – Where my e-mail attachments are stored?

Where my e-mail attachments are stored? Attachments in CRM are stored in ActivityAttachment – “Body” column. SELECT * FROM ActivityAttachment If there is no attachment then FileSize will be Zero.

Posted in CRM Query

Get CRM list of Plug-in using SQL Query

Use below query: SELECT DISTINCT c.LogicalName, a.EventHandlerName, a.SdkMessageIdName, case a.Stage when 10 then ‘Pre Validation’ when 20 then ‘Pre’ when 30 then ” when 40 then ‘Post’ when 50 then ‘Post (Deprecated)’ end as Stage, case a.Mode when 0 then

Tagged with: , ,
Posted in CRM Query

MS CRM User last access time

How to get the last access time for specific user in MS CRM 2015? There is no way directly through front end. You can query database to get the details. Use below query and execute it into your Organization database.

Tagged with: ,
Posted in CRM Query