Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/03/2024 09:15 AM
Hi Team,
We are copying the email value from email attribute to customproperty by using the sav4savrest MODIFYUSERDATAJSON.
we configured the userimport job which is taking the 1 hour 30 minutes to complete, to reduce the time we used the below json, still we see this job is taking 30 minutes to update for 1 user.
Complete Json:
{
"ADDITIONALTABLES": {
"USERS": "SELECT USERNAME,ENTITY,CUSTOMPROPERTY60,CUSTOMPROPERTY3,EMAIL,STATUSKEY FROM USERS WHERE CUSTOMPROPERTY60 IS NULL"
},
"COMPUTEDCOLUMNS": [
"CUSTOMPROPERTY60"
],
"TABLEINDEXES": {
"CURRENTUSERS": [
"USERNAME",
"CUSTOMPROPERTY3",
"STATUSKEY",
"CUSTOMPROPERTY60"
],
"NEWUSERDATA": [
"USERNAME"
]
},
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA u1 left join currentusers u on u1.username=u.username set u1.customproperty60 = (case when (u.email IS NOT NULL and u.STATUSKEY='1' and u.customproperty3 IS NULL and u.customproperty60 IS NULL) THEN u.email ELSE u.customproperty60 END)"
]
}
Please help us to resolve this issue.
Thanks,
Sai Meghana