USP_ROLESYNC_GETROLEGROUPLIST

Gets a list Active Directory groups for a specified System Role to be processed by the RoleSync utility.

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_ROLESYNC_GETROLEGROUPLIST (@SYSTEMROLEID uniqueidentifier)
as
--Used by the RoleSync utility

set nocount on;

select 
    GROUPID, 
    LDAPQUERY, 
    SEARCHROOT, 
    INCLUDESUBCONTAINERS, 
    ID
from 
    dbo.SYSTEMROLEADGROUP
WHERE 
    SYSTEMROLEADGROUP.SYSTEMROLEID = @SYSTEMROLEID