Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Hello everyone,I need help with identifying an issue, i found a solution for my requirement of "assigning the CUSTOMER in users based on the ORGUNITID "i did the following: "UPDATE NEWUSERDATA NU SET NU.customer = (select customername from curren...
Hello everyone,I’m encountering an issue with the a requirement, we have customproperty3 that is getting its value from username, but we need to check that once it is set it doesn't get updated again (CP3 is changed from UI- it should't be back to us...
Hello everyone,We need to ensure that once an identity is created, the username cannot be changed via UI or updates. To enforce this, I found that we could configure it in the Global Config as follows:and i have the following in my modify user json:"...
I'm working department name in Saviynt, The goal is to correctly populate the departmentname and displayname fields during the user import process.Implemented Logic:departmentname is mapped to d:Short~#~char.orgunitid and departmentnumber are mapped ...
i am trying to set the end date on user side but although i have it in modify user json like this: "UPDATE NEWUSERDATA NU SET NU.enddate = CASE WHEN NU.customproperty5 = 'I' THEN CURDATE() ELSE NU.enddate END",in user import json: "enddate": "d:Exi...
thank you @JonasSallstrom ,yes i actually already tried it with "UPDATE NEWUSERDATA NU LEFT JOIN CURRENTUSERS CU ON NU.username = CU.username SET NU.customproperty3 = CASE WHEN CU.customproperty3 IS NULL THEN NU.username ELSE CU.customproperty3 END"...
@rushikeshvartak Thank you but this is also not working and resulted in empty value like the following: and i am having this problem with other attributes as well that updating only when checking if it is empty or null is not working if you have an i...
@rushikeshvartak @Amit_Malik from the logs i can see that issue is that cp34 is getting overwriten with null since: this is getting excuted first 2024-09-11T12:19:28+02:00-ecm-worker--null-rxfk8--"UPDATE NEWUSERDATA NU JOIN CURRENTCUST_USERS CUU ON...
Hello @rushikeshvartak ,i tried to use the query you wrote but it didn't work {
"connection": "acctAuth",
"successResponses": {
"statusCode": [
200,
201,
202,
203,
204,
205
]
}, ...
