Table location of security groups used by CRM deployment RRS feed

  • Question

  • When we setup CRM 2015 on-premise we had to run setup several times due to missing users, missing registry key and several other issues now when I look at the security logins on the database I see many CRM security groups. Examples: 2 PrivReportingGroup, 2 RerportingGroup, 2 SQLAccessGroup. Is there a table in the database that can tell me what groups this CRM instance is really using? 
    Thursday, February 11, 2016 5:17 PM

All replies

  • Run the below against your org databases: -

    select SqlAccessGroupName, ReportingGroupName, PrivReportingGroupName from Organization


    Neil - My CRM Blog

    Thursday, February 11, 2016 10:35 PM