Bulk Account Owner update for AD Accounts

[Shreya47]

Hi team,

We need to update the Owner for multiple AD accounts according to certain AD account attribute (Employee ID is Null). We created an Enhanced Query execution job with 'Insert' operation and the below query, but the job is updating the owner for one account at a time.

SELECT
'3' AS accountowners__OWNERUSERGROUPKEY,
ac.accountkey AS accountowners__ACCOUNTKEY
FROM accountowners ao
right outer join accounts ac on ac.ACCOUNTKEY=ao.ACCOUNTKEY
where ac.customproperty27 is null and ac.ENDPOINTKEY = '1';

where customproperty27 is the Employee ID

Could you please check if there is any wrong configuration in this query or please suggest the best practice to update the Account owner in bulk.

[CR]

try without join

SELECT
'3' AS accountowners__OWNERUSERGROUPKEY,
ac.accountkey AS accountowners__ACCOUNTKEY
FROM accountowners ao
 join accounts ac on ac.ACCOUNTKEY=ao.ACCOUNTKEY
where ac.customproperty27 is null and ac.ENDPOINTKEY = '1';

[AmitM]

HI @Shreya47 , best practice is to use Saviynt REST APIs to do that {{url}}/ECM/{{path}}/updateAccount.

Thanks.

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.

[rushikeshvartak]

use import sheet