how to increment username +1 in select MS SQL query max value

[AJ23494]

Hi Team , 

how to increment max user id through select query in  Global Config-->Identity Lifecycle--> user form. 

Thanks 

Ankit Jindal

[rushikeshvartak]

select max(userkey )+1 as id from users

Admin -> Global Configuration -> Identity Repository  -> Register User Form

[avinashchhetri]

Hi @AJ23494,

What is the use case for this requirement ? The user id i.e userkey is the primary key in the users table and  is  auto incremented. Any new user that gets created gets a non-null, auto incremented value which is unique across the users table.