We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Need help to get the proxyAddresses in userattribute

draut
New Contributor III
New Contributor III

Hi All,

I need help importing the proxyAddresses from the Active Directory to userattribute.

I used the below-mentioned query in USER_ATTRIBUTE JSON in the AD connector.

 

 

 

[username::employeeNumber#String,userattribute_email::proxyAddresses#String,createdate::whenCreated#customDate--yyyyMMddHHmmss.'0Z',updatedate::whenChanged#customDate--yyyyMMddHHmmss.'0Z']

 

 

 

After running the AD import job I am getting an error :

Unknown column 'userattribute_email' in 'field list'

Account Attribute :

 

 

 

[
NAME::sAMAccountName#String,
DISPLAYNAME::displayName#String,
DESCRIPTION::objectCategory#String,
ACCOUNTCLASS::objectClass#String,
accountID::distinguishedName#String,
CREATED_ON::whenCreated#date,
LASTLOGONDATE::lastLogon#millisec,
COMMENTS::distinguishedName#String,
CUSTOMPROPERTY1::manager#String,
CUSTOMPROPERTY2::name#String,
CUSTOMPROPERTY3::sn#String,
CUSTOMPROPERTY4::employeeNumber#String,
CUSTOMPROPERTY5::mail#String,
CUSTOMPROPERTY6::cn#String,
CUSTOMPROPERTY7::givenName#String,
CUSTOMPROPERTY8::title#String,
CUSTOMPROPERTY9::userAccountControl#number,
CUSTOMPROPERTY10::c#String,
CUSTOMPROPERTY11::uSNCreated#String,
CUSTOMPROPERTY35::objectguid#binary,
VALIDTHROUGH::accountExpires#millisec,
UPDATEDATE::whenChanged#date,
RECONCILATION_FIELD::CUSTOMPROPERTY35]

 

 

 

Error Snap  :

Screenshot 2024-01-26 154551.png

Attaching the logs .

Thanks

Dheeraj
1 REPLY 1

rushikeshvartak
All-Star
All-Star

Refer https://forums.saviynt.com/t5/saviynt-knowledge-base/achieve-email-uniqueness-check-during-email-gen...


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.