07/03/2023 12:34 PM
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.
07/03/2023 08:26 PM
I see wrong single quotes in query
update users set systemUserName='lfilho2' where userkey=14666