Username Generation Rule - Auto Increment not respecting in-flight Requests

[Murmur]

Hi everyone, 

I wanted to know, how you handle Username generation. RIght now I have th eissue, that subsequent Requests use the same Username, as the "Auto Increment" Feature does not seem to respect In-Flight requests. 

Any hints how to tackle this? 

Cheers 🙂

[stalluri]

Hello @Murmur,

1. Please refer to below links
https://forums.saviynt.com/t5/general-discussions/incremental-series-in-account-name-rule/m-p/2385
https://forums.saviynt.com/t5/identity-governance/creat-an-auto-increment-unique-username-generation...
https://forums.saviynt.com/t5/saviynt-knowledge-base/how-to-auto-increment-user-id-in-username-gener...
https://docs.saviyntcloud.com/bundle/EIC-Admin-v2021x/page/Content/Chapter06-EIC-Configurations/Conf...

2. Second approach is to use datasets.

[stalluri]

select concat("SE",case when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 1) then concat('00000', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 2) then concat('0000', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 3) then concat('000', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 4) then concat('00', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) when (length(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1)) = 5) then concat('0', CONVERT(greatest(max(substring(raa.attribute_value,3,length(raa.attribute_value)))+1 , MAX(substring(u.username, 3, length(u.username)))+1),CHAR)) END) AS ID from request_access_attrs raa,users u where raa.attribute_name = 'Username' and raa.attribute_value like 'SE0%' and u.username like 'SE0%' and length(u.username) = 8

[rushikeshvartak]

How requests is raised via ARS / Import sheet 

[Murmur]

Hi @rushikeshvartak - The requests are raised via ARS

[Manu269]

@Murmur try using the feature FN_EIC_SEQGEN which is theere in EIC.

You can use the same in your username generation rule.

More Details here : Database Functions (saviyntcloud.com)

[Murmur]

Hi @Manu269 

Thanks for the hint. UNfortunately I'm not able to get it resolved in the "Add Register User Rule". 

I tried the following SQL Queries, with no success: 

• concat('SE',${FN_EIC_SEQGEN('extInc')}) => SE${FN_EIC_SEQGENextInc}
• concat('SE',FN_EIC_SEQGEN('extInc')) => SEFNEICSEQGENextInc

Any hin on how to use this properly here? 

[rushikeshvartak · Accepted solution]

Create dynamic attribute and user user column = Username

[Manu269 · Accepted solution]

Sample :

case when (users.employeetype ='Vendor') then FN_EIC_SEQGEN ('Vendor') when (users.employeetype ='External') then FN_EIC_SEQGEN('External') end

[Murmur · Accepted solution]

Thanks everyone, 

I now used a mix of your suggestions (I believe). 

• New Attribute in Register User Form 
• 
• SELECT CONCAT('SE','-', FN_EIC_SEQGEN('ExtCounterName')) as ID
• Set up the Dataset under Admin > Identity Repository > Dataset > SEQUENCE_GEN_MAPPING
• 
• Set a Value of 10000000 (This prevents the issue of having increasing length, when you start at 0 - Basically what was described above by @stalluri )