USP_DATALIST_SYSTEMROLES

                CREATE procedure dbo.USP_DATALIST_SYSTEMROLES AS
                --Used by the "System Roles" datalist

                --Returns all system roles ordered by name


        declare @ISBBCRM bit; 
        declare @ISBBIDENABLED bit;

        select @ISBBCRM = dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046');
        select @ISBBIDENABLED = dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('WSFederation');

            select 
                      SR.ID,
                      '' AS SECURITYGROUP,
                      SR.NAME,
                      SR.DESCRIPTION,
                      (
                          select 
                              COUNT(*) 
                          from 
                              dbo.SYSTEMROLEAPPUSER AS SRAU
                          where 
                              SRAU.SYSTEMROLEID=SR.ID
                      ) AS 'NUMUSERS',
                      SR.ISSYSTEM,
            case when SR.[NAME] in ('ReportAdmins','ReportBrowsers','ReportBuilders','ReportContentManagers','ReportPublishers') then 1 else 0 end as ISREPORTROLE
                  from 
                      dbo.SYSTEMROLE AS SR
                      left outer join dbo.SYSTEMROLE_CONSTIT_SECURITY_ATTRIBUTE AS SRCSA on SR.ID=SRCSA.ID
                      left outer join dbo.CONSTIT_SECURITY_ATTRIBUTE AS CSA on SRCSA.CONSTIT_SECURITY_ATTRIBUTEID=CSA.ID
          where (@ISBBCRM = 1 and @ISBBIDENABLED = 1) or
                      ((@ISBBCRM = 0 or @ISBBIDENABLED = 0) and SR.NAME not in ('ReportAdmins','ReportBrowsers','ReportBuilders','ReportContentManagers','ReportPublishers'))
                  ORDER BY 
                      SECURITYGROUP, SR.NAME ASC