SQL query for retrieving Site Roles from ConfigMgr Database
If you want to retrieve the site roles from your ConfigMgr environment, you can use the following SQL query:

 select   
      SiteCode,  
      RoleName,   
      ServerName   
 from   
      SysResList

If you have any problems with this, please leave a comment below.

Labels: , ,