web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / how to find Organisati...
Microsoft Dynamics CRM (Archived)

how to find Organisation DB

(0) ShareShare
ReportReport
Posted on by DivyaBharathi 245

Hi All,

Im working in Dynamics CRM  2016 onpremise,

I have been given only the names of servers .

But i dont have the details of Databases expect MSCRM_CONFIG

Is there any way that i can find the Organisation DB and Report server DB by using  MSCRM_CONFIG DB

SELECT [DatabaseName] 
      ,[FriendlyName] 
      ,[SqlServerName] 
      ,[SrsUrl] 
      ,[State] 
      ,[UniqueName] 
      ,[UrlName] 
      ,[IsDeleted] 
  FROM [MSCRM_CONFIG].[dbo].[Organization]

when i tried executing this query its showed me 3 DB but those where pointing to the reporting server.Kindly help me in getting the details of DB pointing the current organisation

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Sreevalli Profile Picture
    Sreevalli 3,256 on at

    Hi,

    It would be yourOrgName_MSCRM

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi ,

    The best way to view report server is using Deployment Manager .

    Open Deployment manager and you will get all organization of particular CRM instance , navigate to Organization link from left panel.

    If you double click on any organization from list you will get the Report server URL form there.

    As Sreevalli suggested above your database name should be prefix with Organization name . If your CRM URL is like below then  -

    http:/servername/ORGNAME/main.aspx

    database name will be -

    ORGNAME_MSCRM

    You will also get all the server details and configuration under "Server"navigation of deployment manager.

    Normally database server are pointed using  using REGEDIT configuration , so you can navigate to registry editor and go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM and under that you can find the all the configuration.

  • Verified answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at

    Hi,

    You will get details of organization DB and Report server url from [MSCRM_CONFIG].[dbo].[Organization] database

    select DatabaseName as OrganizationDatabaseName

    ,SrsUrl as ReportServerUrl

    , UniqueName as OranizationUniqueName

    , SqlServerName as SQLserver

    from Organization

    -- DatabaseName columns will give you organization database name

    -- SrsUrl column will give report server url

    --UniqueName  column will give you organization unique name

    Generally report server database will be  with name "ReportServer" you will find actual database server name from deployment manager, if reports are installed on different server.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans