Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Unable to update systemusername using customquery

Abinash
New Contributor
New Contributor

I'm trying to use below customquery to update the systemusername to match with AD samaccountname, when in the custom query job it failed without updating the systemusername.

Query example:

update users set systemUserName=’lfilho2’ where userkey=14666

 

Please let me know if saviynt have any limitations updating the systemusername. I was able to update the sytemusername in v23.3 and we recently updated to v23.5 and started seeing this issue. Where custom query was unable to updated systemusername.

1 REPLY 1

rushikeshvartak
All-Star
All-Star

I see wrong single quotes in query

update users set systemUserName='lfilho2' where userkey=14666

 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.