Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
10/17/2023 11:07 AM
In our SAVIYNT test environnement we are trying to delete few accounts under Accounts side that are not linked to any CNs. These are bad accounts and due this we are unable to create the another account with same name. How can we mark those junk accounts status as 'DELETED' or 'SUSPENDED FROM IMPORT SERVICES'
Solved! Go to Solution.
10/17/2023 11:58 AM
Hi @Diwakar ,
It’s not possible to hard delete the accounts in Saviynt once imported.
As you want to use same account name and it is in Test environment, better to disable the existing endpoint and create new one and use it.
10/17/2023 09:15 PM - edited 10/17/2023 09:15 PM
update accounts set name=concat(name,'Delet-on-10-03-2023 00:00'),status='SUSPENDED FROM IMPORT SERVICE' where name in ('A') and endpointkey=111 limit 1;
10/17/2023 11:05 PM
Hi @rushikeshvartak Where we need to run this query, when I am running this update query its throwing error: Operation Not allowed. Please update as we need to fix this urgently.
Regards,
Diwakar.
10/18/2023 12:34 AM
Hi @Diwakar ,
Since you're on 23.8, You must use the EnhancedQuery Job
Reference documentation : https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...
See "About the Enhanced Query Execution Job"
10/18/2023 01:41 AM
Thanks a lot Adrein it worked.