How to change the Endpoint Name

[sabyasachi1]

Hi , 
I want to change the name of an endpoint by using Enhanced Query Exexution in JOB. But I am not able to do so.
Here I am using this query:
update endpoints set endpointname ='New Name' where endpointname= 'oldName'limit 1;

But getting the below error at the time of preview.
Error: Operation is not allowed as you are entering a value that resembles or contains SQL Query.

And let me know if it is possible to use endpointkey Instead of endpointname after the Where clause.

Referring Link: https://forums.saviynt.com/t5/identity-governance/how-can-we-change-endpoint-name/td-p/50220.

Regards,
Sabyasachi Mohanty

[NM]

@sabyasachi1 make use of enhanced query.

[sabyasachi1]

Hi @NM 
I am using  Enhanced Query Execution in JOB type.

[rushikeshvartak]

Sample query 

select 'Active Directory' as endpoints__endpointname ,'Active Directory Display' as endpoints__displayname ,endpointkey as endpoints__primarykey from endpoints where endpointkey=2 limit 1;

[SumathiSomala · Accepted solution]

@sabyasachi1  Try below using Enhanced Query Execution in JOB type. 

SELECT  '<endpointname>' AS ENDPOINTS__ENDPOINTNAME , ep.endpointkey as  ENDPOINTS__PRIMARYKEY  FROM ENDPOINTS  ep where ep.status=1 and ep.endpointkey=7;

[Raghu]

@sabyasachi1  Think are using 24.5v , Custom query's deprecated 23.9v, you need to prepare  enhanced query format it work.

more info : https://docs.saviyntcloud.com/bundle/Release-Notes/page/Content/v23/Release-Notes-23-9.htm

Example :

select 'New Name' as ENDPOINTS__ENDPOINTNAME,a.ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS a where A.ENDPOINTNAME = 'oldName'