How to Delete junk Accounts in Saviynt

[Diwakar]

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'

[pmahalle]

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.

[rushikeshvartak]

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;

[Diwakar]

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.

[adriencosson · Accepted solution]

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"

[Diwakar]

Thanks a lot Adrein it worked.