UFN_SYSTEMROLE_GETGROUPLIST

            CREATE FUNCTION dbo.UFN_SYSTEMROLE_GETGROUPLIST(@SYSTEMROLEID uniqueidentifier)
            /*
            Returns a table of active directory groups and LDAP queries from which to synchronize users into this role
            */
            returns table
            as
            return
                (select 
                    ID, 
                    GROUPID, 
                    LDAPQUERY, 
                    GROUPNAME, 
                    DISPLAYNAME, 
                    SEARCHROOT, 
                    INCLUDESUBCONTAINERS, 
                    OVERWRITEEXISTINGSECURITY,
                    SECURITYMODECODE,
                    BRANCHSITEID
                from 
                    dbo.SYSTEMROLEADGROUP
                where 
                    SYSTEMROLEADGROUP.SYSTEMROLEID = @SYSTEMROLEID
                )