Analytics to rename the account name

[Saviynt_Savvy]

How to write analytics to rename the accounts in specific endpoints when the status of accounts are "Manually Suspended".

Any example of an analytics query would help.

Thanks & Regards,
SaviyntSavvy

[rushikeshvartak]

• You can't update any account name using analytics.
• Use below enhanced query for same.

  Select ACCOUNTKEY AS accounts__PRIMARYKEY, concat (name, '-SUSPENDED',' ','on-',current_Timestamp) AS accounts__NAME,'SUSPENDED FROM IMPORT SERVICE' AS accounts__STATUS From accounts Where status in ('Manually Suspended')and endpointkey='5' LIMIT 1;