Saviynt Username logic - Need to restrict lowercase letters

[JB]

Hello Team,

We are generating a 7 digit code in Saviynt using “Add Register User Rule” (OOTB feature – Global config)

Ex: aE406aa, wf494aa, QH743aa

We need only Upper case letters in generated code, currently we are getting both upper case and lower case letters. Is there any option available ?

Regards,

JB

[This post has been edited by a Moderator to remove sensitive information.]

[rushikeshvartak]

upper(concat(SUBSTRING('abcdefghijklmnopqrstuvwxyz' FROM FLOOR(RAND() * 26) + 1 FOR 1),
SUBSTRING('abcdefghijklmnopqrstuvwxyz' FROM FLOOR(RAND() * 26) + 1 FOR 1),LPAD(FLOOR(RAND() * 100), 2, '0') ,SUBSTRING('abcdefghijklmnopqrstuvwxyz' FROM FLOOR(RAND() * 26) + 1 FOR 1),
SUBSTRING('abcdefghijklmnopqrstuvwxyz' FROM FLOOR(RAND() * 26) + 1 FOR 1))