Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/18/2024 03:33 AM
We have a fresh Saviynt Tenant setup. We are trying to generate the unique system user name. We have written the following standard logic to test whether system is generating the unique system user name or not but what I observed is that it is generating the username based on the default logic like if it is a 10th user in system the user name will be 10 but not utilizing our system user name generation logic
------------------
concat(users.firstname , substring('.',1,1) , users.lastname) ### CASE WHEN (users.middlename is NOT NULL) THEN concat(users.firstname , substring('.',1,1) , substring(users.middlename,1,1) , substring('.',1,1) , users.lastname) END ### concat(users.firstname , substring('.',1,1) , users.lastname , substring('1',1,1))### concat(users.firstname , substring('.',1,1) , users.lastname , substring('2',1,1))### concat(users.firstname , substring('.',1,1) , users.lastname , substring('3',1,1)
Feed file is like :
statuskey,FIRSTNAME,MIDDLENAME,LASTNAME,PREFEREDFIRSTNAME,CUSTOMPROPERTY1
1,Joè,John,Dne,John,test
06/18/2024 07:56 PM