Store Account Attribute Custom Property in User_Attributes table

[sdey_2023]

Hi Team,

We are trying to fetch a particular custom property from all the Accounts within an Endpoint and store it in the User_attributes table so that it is used while email generation to check for uniqueness by Saviynt.

We are referring the below KB but our requirement is to include the orphan accounts as well:

Achieve Email uniqueness check during email genera... - Saviynt Forums - 40223

We are performing an account import from ADSI target system and trying to store the value of CP23 from account attribute to the User_attributes table via Sav4Sav job, but unable to refer the orphan accounts in the process.

[dgandhi]

To which user you want to map the orphan account attribute? Can you please elaborate on the requirement?

[sdey_2023]

The requirement is that we need to store all the CP23 of the accounts to User_Attributes data column so that it can be used during uniqueness check of email generation. Many orphan accounts are present as well for which we are looking for a solution to store their CP23 values in the User_attributes table. Is there any way to achieve this via Sav4Sav job?

[rushikeshvartak]

Please share json / xml of sav4sav

[sdey_2023]

Hi Rushikesh,

We are unable to refer to the orphan accounts in the Sav4Sav job. Is there any way to store a particular CP of the accounts table to the User_attributes table by doing some preprocess operation?

<dataMapping>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name">
<![CDATA[select customproperty23 as proxy from accounts where endpointkey=6; ]]>
</sql-query>
<importsettings>
<zeroDayProvisioning>false</zeroDayProvisioning>
<userNotInFileAction>NOACTION</userNotInFileAction>
<checkRules>true</checkRules>
<userOperationsAllowed>UPDATE</userOperationsAllowed>
</importsettings>
<mapper description="This is the mapping field for Saviynt Field name" defaultrole="ROLE_END_USER" dateformat="date">
<mapfield saviyntproperty="user_attributes.data" sourceproperty="proxy" type="character"/>
</mapper>
</dataMapping>

And then maybe try to use ModifyJson to preprocess the data, but this approach is not working.