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

How to Trigger a Microsoft Flow from a Custom Button in Dynamics 365

  When using Microsoft Flow the out-of-the-box button is nested under the ‘Flow’ section and is not easy to find nor is it customizable. Tri...