USP_SYSTEMROLE_ADGROUPLIST

Gets a list of active directory groups to be synchronized with this System Role.
Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_SYSTEMROLE_ADGROUPLIST
            (
                @SYSTEMROLEID uniqueidentifier
            )
            as
                --Used by the System Role page

                set nocount on;

                select 
                    SYSTEMROLEADGROUP.ID, 
                    SYSTEMROLEADGROUP.GROUPID, 
                    SYSTEMROLEADGROUP.LDAPQUERY, 
                    SYSTEMROLEADGROUP.GROUPNAME, 
                    SYSTEMROLEADGROUP.DISPLAYNAME, 
                    SYSTEMROLEADGROUP.INCLUDESUBCONTAINERS,
                    SYSTEMROLEADGROUP.SECURITYMODECODE,
                    SYSTEMROLEADGROUP.SECURITYMODE,
                    (select 
                        dbo.UDA_BUILDLIST(SITE.NAME) 
                    from 
                        dbo.SITE 
                        inner join dbo.SYSTEMROLEADGROUPSITE ON SYSTEMROLEADGROUPSITE.SITEID = SITE.ID
                    where
                        SYSTEMROLEADGROUPSITE.SYSTEMROLEADGROUPID = SYSTEMROLEADGROUP.ID
                    ) as SITELIST,
                    SYSTEMROLEADGROUP.OVERWRITEEXISTINGSECURITY,
                    isnull(SITE.NAME, '') as BRANCHSITENAME,
                    SYSTEMROLEADGROUP.CONSTITUENTSECURITYMODECODE,
                    SYSTEMROLEADGROUP.CONSTITUENTSECURITYMODE,
                    (select 
                        dbo.UDA_BUILDLIST(CONSTIT_SECURITY_ATTRIBUTE.NAME) 
                    FROM 
                        dbo.CONSTIT_SECURITY_ATTRIBUTE 
                        inner join dbo.SYSTEMROLEADGROUPCONSTITUENTSECURITY ON SYSTEMROLEADGROUPCONSTITUENTSECURITY.CONSTITUENTSECURITYATTRIBUTEID = CONSTIT_SECURITY_ATTRIBUTE.ID
                    where
                        SYSTEMROLEADGROUPCONSTITUENTSECURITY.SYSTEMROLEADGROUPID = SYSTEMROLEADGROUP.ID
                    ) as CONSTITUENTSECURITYGROUPLIST
                from 
                    dbo.SYSTEMROLEADGROUP
                    left outer join dbo.SITE on SITE.ID = SYSTEMROLEADGROUP.BRANCHSITEID
                where 
                    SYSTEMROLEADGROUP.SYSTEMROLEID = @SYSTEMROLEID