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

Git Basic working