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

how to generate uesrname, systemusername and email in lowercase in Saviynt

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on October 14 2020 at 14:33 UTC

Hi Can we generate username, systemusername and email all in lowercase.


Below is screenshot of logic:

image


This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.
3 REPLIES 3

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on October 21 2020 at 08:27 UTC

Hi Shashank,


With basic, we can configure in lower case. There is a hack for it i.e. go to DB , query configuration table and make change for the rule.


For example if your rule is users.username then just add lower(rule as created in db).


final would be lower(users.username).



Thanks

Ajay

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on October 21 2020 at 13:02 UTC

Can you please share more details.


We have logic like for firstname and lastname

userlogin for first distinct user: flastname

userlogin for next distinct user filastname

userlogin for next distinct user firlastname

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on October 21 2020 at 13:12 UTC

Hi,


Below is the rule to generate systemusername rule in lower case. You will have to add this to DB directly.


lower(concat(substring(users.firstname,1,1) , users.lastname) # concat(substring(users.firstname,1,2) , users.lastname) # concat(substring(users.firstname,1,2) , users.lastname) )


Thanks

Ajay

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.