Delete account from actionable analytics

[rmishra]

Dear experts,

I am seeking assistance regarding the deletion of an account that is currently not mapped to any identity/users. The objective is to initiate the removal of the account via the JSON connection and subsequently delete the account from Active Directory. I am exploring the possibility of achieving this through actionable analytics. If this is feasible, could you please provide the relevant query for implementation? Alternatively, if there is another recommended approach, kindly share your suggestions.

Thank you for your prompt attention and expertise.

Best regards,

Rohit

[pmahalle]

Hi @rmishra ,

Which connector you are using here ? Also, are you planning to delete it in target application as well?

[rushikeshvartak]

In query userKey is mandatory use 1 as userKey which will trigger delete account for orphan account

[dgandhi]

 

Check below link:

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...

Delete Account

When Delete Account is configured as an allowed action, it deletes an account from EIC. When this action is performed on a record, a Delete Account task is created for deleting the account in the target application.

The Analytics query must have the columns given below:
acctKey - Stores accountkey of the account which has to be deleted.

Sample query:

• Schedule from Run All V2 Analytics Job

SQL

select a.name,a.accountkey as acctKey, endpointkey, 'deleteAccount' as Default_Action_For_Analytics from accounts a;

• Schedule from Run All V1 Analytics Job

SQL

select a.name,a.accountkey as acctKey, endpointkey, 'Delete Account' as Default_Action_For_Analytics from accounts a;