Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Can you help on below Customquery to Enhanced query

NardnraP
New Contributor II
New Contributor II

Hi All,

Please provide below one to Enhanced query

update accounts set NAME = concat(Name,'-Removed',' ','on-',CURRENT_TIMESTAMP) ,REFERENCED_ACCOUNTKEY = null, STATUS = 'SUSPENDED FROM IMPORT SERVICE' where SYSTEMID IN (39) and STATUS in ('Manually Suspended','2','Inactive') and NAME not like '%Removed on%';

2 REPLIES 2

Raghu
All-Star
All-Star

@NardnraP  try below

Sample :

select concat(a.name,'-Removed',' ','on-',CURRENT_TIMESTAMP) as accounts__name,'SUSPENDED FROM IMPORT SERVICE' as accounts__status,a.accountkey as accounts__primarykey from accounts a where a.SYSTEMID IN (5) and a.STATUS in ('Manually Suspended','2','Inactive') and NAME not like '%Removed on%';

Note : systemid you can change as per application


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak
All-Star
All-Star

Select accountkey as accounts__primarykey,concat(name,'-Removed',' ','on-',CURRENT_TIMESTAMP) as accounts__name,'SUSPENDED FROM IMPORT SERVICE' as accounts__status,

null as accounts__REFERENCED_ACCOUNTKEY

from accounts where SYSTEMID IN (39) and STATUS in ('Manually Suspended','2','Inactive') and NAME not like '%Removed on%';

 

since you are on v24.2 setting null will not work. This has been fixed in v24.5

https://docs.saviyntcloud.com/bundle/Release-Notes/page/Content/v24x/Release-Notes-24-5.htm#top

 
  •  

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.