Editing user table attributes

[BillyMai]

How can we edit the user's customproperty without the CUSTOMQUERYJOB and using the new Enhanced Query Execution? The use-case is, when we deprovision/remove an account, we need to take the date that the remove account task got completed and add that date to the user's custom property.

[pmahalle]

Hi @BillyMai ,

You can achieve this using update user config and update rule. Follow below steps for the same.

1. Add below query in UPDATEUSERJSON in Saviynt connection .

{"updateUserQry":["UPDATE USERS SET U.CUSTOMPROPERTY10=curdate() where U.USERKEY=${user.id}"]}

2.  Add action Create Update User Task with Saviynt connection where you have added UPDATEUSERJSON in above step in the same update rule which you are using for remove account.

It will create update user task once you update rule executed. After you run the Wsretry job, task will be completed and custom property10 will populated with current date.

Let me know if it helps.

[dgandhi]

Please check below link for sample:

https://docs.saviyntcloud.com/bundle/EIC-FAQ/page/Content/FAQs.htm

Search with "Enhanced Query Execution"

[dgandhi]