How to get the sql server database of an organization?

I want to share a quick tip that learned today.

Within Deployment Manager, when we double click an Organization we have this data available to see (or edit if organization is disabled):

What happens if we want to know exactly which SQL Server Database corresponds to each organization? Normally their names matches but sometimes (as happened today to me) it doesn’t ;).

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]

(result)

Hope you find this helpful,

PP [twitter: @pabloperalta]