USP_SYSTEMROLEADGROUP_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@SYSTEMROLEID	uniqueidentifier	IN
@GROUPID	varbinary	IN
@LDAPQUERY	nvarchar(max)	IN
@DISPLAYNAME	nvarchar(255)	IN
@SEARCHROOT	nvarchar(1024)	IN
@INCLUDESUBCONTAINERS	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy


                create procedure dbo.USP_SYSTEMROLEADGROUP_ADD
                (
                    @ID uniqueidentifier = null output,
                    @SYSTEMROLEID uniqueidentifier = null,
                    @GROUPID varbinary(85) = null,
                    @LDAPQUERY nvarchar(max) = '',
                    @DISPLAYNAME nvarchar(255) = '',
                    @SEARCHROOT nvarchar(1024) = '',
                    @INCLUDESUBCONTAINERS bit = 1,
                    @CHANGEAGENTID uniqueidentifier = null    
                )    
                as

                --adds a new SystemRoleADGroup to the database

                set nocount on;

                declare @CURRENTDATE datetime
                set @CURRENTDATE = GetDate()

                if @ID is null
                    set @ID = NewID()

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output


                --Create System Role ADGroup
                insert into dbo.[SYSTEMROLEADGROUP]
                    (
                    [ID],
                    [SYSTEMROLEID], [GROUPID], [LDAPQUERY], [DISPLAYNAME], [SEARCHROOT], [INCLUDESUBCONTAINERS],
                    [ADDEDBYID], [CHANGEDBYID], [DATEADDED], [DATECHANGED])

                    values
                    (@ID,

                    @SYSTEMROLEID, @GROUPID, @LDAPQUERY, @DISPLAYNAME, @SEARCHROOT, @INCLUDESUBCONTAINERS,

                    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

                if @@error <> 0 return -7;

                return  0;