USP_ADORGANIZATIONALUNIT_ADD

Adds a new organizational unit to the ADORGANIZATIONALUNIT table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@NAME	nvarchar(64)	IN
@OUPATH	nvarchar(1000)	IN
@GROUP	nvarchar(64)	IN
@USERNAMESUFFIX	nvarchar(10)	IN
@USERACCOUNTSID	varbinary	IN
@USERPWD	nvarchar(180)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_ADORGANIZATIONALUNIT_ADD
(
    @ID uniqueidentifier = null output,
    @NAME nvarchar(64),
    @OUPATH nvarchar(1000),
    @GROUP nvarchar(64) = '',
    @USERNAMESUFFIX nvarchar(10) = '',
    @USERACCOUNTSID varbinary(85),
    @USERPWD nvarchar(180),
    @CHANGEAGENTID uniqueidentifier = null
)
as

set nocount on;

declare @CURRENTDATE datetime

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

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

if @GROUP is null
    set @GROUP = ''   

set @CURRENTDATE = getdate()

begin try
    -- Open the symmetric key for encryption

    exec dbo.USP_GET_KEY_ACCESS;


    -- handle inserting the data

    insert into dbo.ADORGANIZATIONALUNIT
        (ID, [NAME], OUPATH, [GROUP], USERNAMESUFFIX, USERACCOUNTSID, USERPWD, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (@ID, @NAME, @OUPATH, @GROUP, @USERNAMESUFFIX, @USERACCOUNTSID, EncryptByKey(Key_GUID('sym_BBInfinity'), @USERPWD), @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

    close symmetric key sym_BBInfinity;
end try

begin catch
    exec dbo.USP_RAISE_ERROR

    -- Make sure we close the symmetric key

    close symmetric key sym_BBInfinity;

    return 1
end catch

return 0