INCREMENTINDEX in accountnamerule advanced config

[galaxy1]

Hi All, 

I want to autoincrement value in accountnamerule using advanced config 

this is my query- concat(lower(users.lastname),lower(substring(users.firstname,1,1)))###INCREMENTINDEX##

auto increment doesn't work I dont see anything specific in logs too. 

can someone please suggest if auto increment works in advanced config?

[Saathvik]

Try using FN_EIC_SEQGEN default function to do auto increment. You can find more details here about this function

[galaxy1]

Hi Saathvik, 

This is creating the accountnames in sequence, like user1 is requesting access it will be abc1, if user2 with different username is requesting access it will be abc2, 

only duplicate entries needs to be autoincremented, any suggestions for it please?

this is my query: concat(lower(users.lastname),lower(substring(users.firstname,1,1)),FN_EIC_SEQGEN('username'))