Monday, 20 August 2018

How to get Organization & Sql Server Database name in MS CRM using SQL Server



i had  a problem to figure out what database is used and which one is production. 
finally i got the solution to my problem for configuring the Dynamics CRM installation


SELECT DatabaseName [DATABASE NAME],
FriendlyName [ORGANIZATION NAME],
SqlServerName [SQL SERVER NAME],
SrsUrl [SSRS URL],
[ORGANIZATION STATUS] =
CASE
WHEN STATE=1 THEN 'ENABLED'
WHEN STATE=0 THEN 'DISABLED'
END
FROM 
[MSCRM_CONFIG].[DBO].[ORGANIZATION] 

No comments:

Post a Comment

Introduction to Dynamics 365 CE Data Migration using ADF

Dynamics 365 CE Data Migration using ADF can be necessary for various reasons, such as archiving historical data, integrating with other sys...