It is not mandatory to have the same CRM Organization Name (On-Premises) with same Database Name in Sql Server.
So to check which Oragnization pointing to the database can be known by using the below query
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]
Please share your valuable feedback on this article.
Thanks man you saved my time
LikeLike
Welcome ๐
LikeLike
This Excellent Query; Which help me lot of time.
LikeLike
Thank you ๐
LikeLike