Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/30/2024 03:01 AM
Can someone help me in converting below sql query into an Enhanced execution query (update operation)
1) update accounts set status='SUSPENDED FROM IMPORT SERVICE' where endpointkey=12 and name like '%on-%' and status in ('2','Manually Suspended');
2)
UPDATE accounts ac, user_accounts ua SET ac.accounttype='P' WHERE ua.accountkey = ac.accountkey AND ac.status='1' and ac.name not like '%\_%' and ac.accounttype is null and ac.endpointkey=13
09/30/2024 03:43 AM
1 st query :;
select 'SUSPENDED FROM IMPORT SERVICE' as accounts__status,a.accountkey as accounts__primarykey from accounts a where a.ENDPOINTKEY = 12 and a.name like '%on-%' and status in ('2','Manually Suspended');
2nd query have "user_accounts " this table dont have permissin update via script try other way
UPDATE accounts ac, user_accounts ua SET ac.accounttype='P' WHERE ua.accountkey = ac.accountkey AND ac.status='1' and ac.name not like '%\_%' and ac.accounttype is null and ac.endpointkey=13