Username Generation Conflict Dealing With Multiple User Sources

[Sivagami]

We have 2 sources through with the users are created. One via Saviynt (Create User Form) and one via HR Source.

Username generation logic is used with Auto increment like below. (Basic Config)

Constant value USER + 1 character from firstname + 1 character from lastname + Auto increment from 10000

So usernames will look like below -> USERFL10000, USERFL10001, etc.,

Users created via register user go through approval before they are created. 

We had a scenario where let's say USERFL10000 was in approval state post create user form was submitted and in the meanwhile a user from HR source with same firstname and lastname initials came, the system issued USERFL10000 as username for the user imported from HR source. And when the user requested via create user form got approved, they were never created due to the user with same username - USERFL10000 existing in user table.

Appreciate your insights on how this issue can be resolved.

-Siva

[rushikeshvartak]

You need to check used username in request_access_attrs table.

Refer sample https://forums.saviynt.com/t5/identity-governance/username-generation-rule/m-p/11630

[Sivagami]

Hi @rushikeshvartak , We are using basic configuration with autoincrement for username generation and the dynamic attribute in create user form just maps to the user attribute username. When the user is pulled from HR source as well, the same username generation rule is hit and issues the username. How do we resolve issue in this case?

-Siva

[rushikeshvartak]

Using advanced confiy

[Sivagami]

How can you access request_access_attrs in advanced config of username generation as it's not a dynamic attribute.

Username generation rule is used to commonly generate username between users created from this create user form and users imported from HR source.

-Siva

[rushikeshvartak]

try writing inner select query

[Sivagami]

Username generation rules support it?

[rushikeshvartak]

I have not tried. But you can explore

[Sivagami]

As per Solved: UserName Generation Rule - Saviynt Forums - 40822, Select statements doesn't work in username generation rule but works in system username generation rule.

[rushikeshvartak]

Raise idea ticket 😂