How to assign saviynt generated systemusername to username column

[sampath18]

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

[rushikeshvartak · Accepted solution]

Add same rule for username in global config

[sampath18]

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

[rushikeshvartak]

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