Facing issue in creating username generate rule

[Deepu]

Hello,

We are facing an issue while creating the username using the username generation rule. Below is the advanced configuration we are using

CONCAT(
LOWER(LEFT(users.firstname, 1)),
LOWER(LEFT(users.middlename, 1)),
LOWER(LEFT(users.lastname, 1)),
LPAD(FLOOR(RAND() * 10000), 4, '0'),
'@xyz.com'
)

• Everything in lowercase
• Firstname initial character 1
• Middlename initial character 1
• Lastname initial character 1
• random 4-digit numeric value without any specific limitations on the value
• Custom string initial character: @xyz.com

Output:-

Thanks

[SumathiSomala]

@Deepu Advance Query option does not working in Add Register User Rule 

Refer below forum threads

RAND() - Username Generation Advanced Query - Saviynt Forums - 21213

Solved: How to add length restriction in Add Register User... - Saviynt Forums - 2308

Add Register User Rule: Advanced Config does | Saviynt Ideas Portal

If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.