Multiple insert statement in Enhanced Query

[Ankit_Singh]

I want to insert multiple rows in account owners table via enhanced query. But it is taking only 1.

Anyone have any idea of Inserting multiple rows.

[Raghu]

you can use 'union' for multiple insert enhanced query execution.

example :

select 'India' as accounts__customproperty1,accountkey as accounts__primarykey from accounts where accountkey=1234 union
select 'Israel' as accounts__customproperty1,accountkey as accounts__primarykey from accounts where accountkey=12345

[Ankit_Singh]

Need to do it dynamically using below query.

select
a.accountkey AS accountowners__accountkey,
ao.accountownerkey AS accountowners__PRIMARYKEY,
u.userkey AS accountowners__OWNERUSERKEY,
1 AS accountowners__RANK ,
sysdate() AS accountowners__UPDATEDATE ,
1 AS accountowners__UPDATEUSER
from
accountowners ao, accounts a, users u where u.username = a.customproperty20
and a.displayname like '%flkbot%'

[Raghu]

it will work dynamic also, may be where cause chck once query execution time

[rushikeshvartak]

Account owner table dynamic insert is not supported 

https://forums.saviynt.com/t5/identity-governance/enhanced-query-execution-to-update-account-owner/m...

[Ankit_Singh]

Hi @rushikeshvartak ,

How to convince customer. They want an automated process for it. A scheduled job like thing which need not manual intervention. 

Do you have any idea how to do that.

[rushikeshvartak · Accepted solution]

You need to do manually no alternatives. Even actionable report also supports manual intervention 

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

[Raghu]

job scheduling automation procces only , we are not doing manually hit job everytime , you can explain clearly them.