Can we use Enhanced Query Execution to flag large number of accounts as Suspended

[Claudio_Origin]

Hello,

we are decommissioning (removing) many of our SAP endpoints. They have 1000's of accounts. Before we disable the endpoints, security systems and connectors we need to remove all active accounts.

The usual method of running a V2 Analytic to Deprovision Accounts then complete the tasks is very tedious and time consuming.

Is it possible to use Enhanced Query Execution to set these accounts to Manually Suspended state and speed up the process of deprovisioning. 

Also completing 1000's of tasks is the next hurdle - even if it's manually completing them, the UI hists timeouts. Any ideas would be welcome please.

[sk · Accepted solution]

Can you clarify when you say remove all accounts, Are you expecting it to be removed on target? If so marking them Manually Suspended using query job will not help right?

So trying to understand the actual use case you want to achieve.

Coming to limitation question documentation explicitly doesn't say any limitation but I still assume they might have some limitation because whole point to deprecate old process is it to put some guardrails. So you may have to give it a try and figure it out

[Claudio_Origin]

Hi Saathvik, yes we have used the Enhanced Query Execution to flag the accounts as suspended. See example below:

---

---

SELECT 'SUSPENDED FROM IMPORT SERVICE' AS ACCOUNTS__STATUS ,
concat(concat(a.name,"-Deleted on-"),now()) AS ACCOUNTS__NAME, a.accountkey as ACCOUNTS__PRIMARYKEY
FROM ACCOUNTS a
WHERE a.status = 1 AND a.endpointkey = 30;

Thanks,

[rushikeshvartak]

Does deleted keyword supported in enhanced query

[Claudio_Origin]

Hello - the word Deleted that you see is part of a string used inside a Concat function, yes it was accepted.