Change the account name and status using Analytics.

[Saviynt_Savvy]

Hello All,

I need to create an analytics to change the account name and status in some endpoints.
I can validate the below query in the "Data Analyzer" and change the account name and status, but the same is not acceptable in Analytics as the word status cannot be used in Analytics.

Is there any way how to rename the account status as "Suspended from Import Service" using "Analytics".

Use case:
For a terminated user, rename the "account name" and "status" of the user accounts in specific endpoints. 

Query:
SELECT concat(name,'-Deleted on-',sysdate()) as name, "SUSPENDED FROM IMPORT SERVICE" as status, ac.accountkey as acctKey FROM accounts ac where ac.accountkey IN ( SELECT a.accountkey FROM accounts a JOIN user_accounts ua ON a.accountkey = ua.accountkey JOIN users u ON ua.userkey = u.userkey JOIN endpoints ep ON a.endpointkey = ep.endpointkey WHERE ep.endpointname IN ('Commercial','Encompass Support','Enterprise Automation') AND a.status IN ('Manually Suspended') AND a.name NOT LIKE "%Delete%" and U.STATUSKEY=0)

Output in Data Analyzer:

How to write the query in Analytics to change the account name and status

Thanks & Regards,
Saviynt Savvy

[rushikeshvartak]

• This is not supported by analytics instead use enhanced query
• SELECT
  CONCAT(ac.name, '-Deleted on-', SYSDATE()) AS accounts__name,
  'SUSPENDED FROM IMPORT SERVICE' AS accounts__status,
  ac.accountkey AS accounts__primarykey FROM
  accounts ac
  WHERE
  ac.accountkey IN (
  SELECT
  a.accountkey
  FROM
  accounts a
  JOIN user_accounts ua ON a.accountkey = ua.accountkey
  JOIN users u ON ua.userkey = u.userkey
  JOIN endpoints ep ON a.endpointkey = ep.endpointkey
  WHERE
  ep.endpointname IN ('Commercial', 'Encompass Support', 'Enterpris