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

[Community_User]

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:

[Community_User]

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

[Community_User]

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

[Community_User · Accepted solution]

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