USP_ADORGANIZATIONALUNIT_GETPATHANDUSERINFO

Returns the organizational unit name, path, default group, and the user name and password stored in the ADORGANIZATIONALUNIT table

Parameters

Parameter	Parameter Type	Mode	Description
@ORGUNITID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_ADORGANIZATIONALUNIT_GETPATHANDUSERINFO
    (
    @ORGUNITID UNIQUEIDENTIFIER 
    )
as
begin

    set nocount on;

    --open key to decrypt USERPWD value

    exec dbo.USP_GET_KEY_ACCESS;

    select 
        [NAME], OUPATH, [GROUP], USERNAMESUFFIX, USERACCOUNTSID, 
        CAST(DecryptByKey(USERPWD) AS NVARCHAR(128)) as USERPWD_DECRYPTED,
        TSLONG
    from dbo.ADORGANIZATIONALUNIT
    where ID = @ORGUNITID

    close symmetric key sym_BBInfinity;

    return 0;
end