and more in a single search tool across platforms. Read the announcement here. |
03/11/2024 05:55 AM
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.
03/11/2024 06:18 AM
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';
03/11/2024 08:01 AM
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.
03/11/2024 08:09 PM
use import sheet