Sunday, December 1, 2013

How to get the sql server database of an organization?

In the deployment manager, we can't see the name of the Database...
So, the quick tip is querying Organization table from MSCRM_CONFIG database in order to find out this information.
 By running this 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]

Example :



Post a Comment