Tuesday, February 13, 2018

Know your MS Dynamic CRM organization database name




While working in MS Dynamic CRM there can be a case when your database name is not similar to the organization name and sometime it’s difficult to find the correct database name which is pointing to the organization.

By running below query within MSCRM_CONFIG database we should be able to easily identify each organization:

SELECT [DatabaseName]
      ,[FriendlyName]
      ,[SqlServerName]
      ,[SrsUrl]
      ,[State]
      ,[UniqueName]
      ,[UrlName]
      ,[IsDeleted]
  FROM [MSCRM_CONFIG].[dbo].[Organization]


No comments:

Post a Comment

QueryExpression vs. FetchXML in MS CRM with C#

Microsoft Dynamics CRM (Customer Relationship Management) is a powerful platform that helps organizations streamline their business processe...