Hi Team,Recently our saviynt account import job(DB connection) failed with some duplicate entry error. On checking the issue, we did not find any duplicate entry. There were some timebound roles assigned to users, when the job failed it deleted all t...
Hi Team,We have a requirement to view the threshold value mentioned in all the connections created till date. There are 300 + connections. Is there any way (any table/ column) which will be able to extract the threshold value from all the connection ...
We have a custom query job which is used to update some attribute of accounts present in one endpoint after validating the value of account present in other endpoint. It takes 4-5 hours and then fails with error 'connection has already been closed'....
We have a requirement to do cleanup of accounts. Could you please help with the ways how saviynt performs cleanup of accounts from Backend. Is it done via query of file upload? Also, can the risks involved with cleanup be mentioned?
Hi Team,We have a SOAP connection where we are importing data of users from Workday for identity type A. SO, if user has identity type A and one of the custom property mentioned as B, we say user is present in Workday and data will be imported from W...
Hi@rushikeshvartak ,Thanks. So, below JSON will help to make sure if job fails, then not more than 15 entitlements will be removed?"entThresholdValue": {"entType": {"DBROLE": {"ent": 15
Hi Rushikesh,1. No such mapping was updated in connection or accounts.2. yes- threshold will be reduced. we wanted to know the criteria how DB job will delete the account if fails. In this case, when job got this error- will it deleted all the accou...
Hi @rushikeshvartak , The query can longer be optimized, we tried applying various filters as well but that too didn't help. This was checked with saviynt for ticket as well where they confirmed the query can not be more optimized. Hence, we need to ...
Hi,This was an activity that was done earlier back in 2020/ 2021 by saviynt for us as per request. We have accounts as deleted in saviynt but need to clear them off or remove them from saviynt.
Below is the query:"PREPROCESSQUERIES": ["UPDATE NEWUSERDATA SET USERNAME = TRIM(LEADING '0' FROM USERNAME);","UPDATE NEWUSERDATA N1 LEFT JOIN CURRENTUSERS U ON TRIM(LEADING '0' FROM N1.USERNAME)=U.USERNAME SET N1.USERNAME = CASE WHEN (U.REGIONCODE <...
