Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/30/2024 06:29 AM
Can anyone help me in converting below sql query into an Enhanced Query?
Thanks in advance.
UPDATE arstasks ar,
accounts acc,
endpoints ep
SET
ar.PROVISIONINGCOMMENTS = CONCAT(COALESCE(ar.PROVISIONINGCOMMENTS, ''),
'System closing task as account has been identified as a secondary AD account'),
ar.STATUS = 4
WHERE
ar.tasktype in (12,6)
AND ar.accountkey = acc.accountkey
AND acc.endpointkey = ep.endpointkey
AND ep.ENDPOINTNAME = 'XYZ'
AND ar.STATUS = 1
AND acc.name LIKE '%#_%' ESCAPE '#';