Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

How to assign saviynt generated systemusername to username column

sampath18
Regular Contributor II
Regular Contributor II

Hi Experts,

I have very basic query but finding difficult to identify an answer. So query is i am generating system username for new users and that is generated systemusername as expected. But we need to use the same value in username attribute as well. Saviynt is considering these two are different. Hence can you advice how i can assign the system generated systemusername to username attribute.

I tried using preprocessor but it is failing saying as unknown column.

"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET username =NEWUSERDATA.SYSTEMUSERNAME"
]

can anyone here please advise how to overcome this.

It would be greatly appreciated.

Thanks,

Sampath

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

Add same rule for username in global config


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

sampath18
Regular Contributor II
Regular Contributor II

Thanks Rushi. It was quick help from you.

I just want to know if there is any other way to do this using preprocessor json

Regards,

sampath

username is primary recon key so you may not be able to do it


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