Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Need information regarding username generation using Saviynt Username Custom Query

SIRAJMOLLA
New Contributor III
New Contributor III

Hi All,

How to auto increment user id with a custom logic The requirement is that Username Generation Rule should Auto increment as per following scenario:

Scenario :

1. Username creation needs to be in format : "AA8001"

2. Username should have fix length of 6.

3. At each user creation the last digit should increase from (1 -> 2 ->............9 -> 0).

4. Once the last digit reach number 0(Maximum), it will loop and increase first 2 digit like(AA -> AB ->...-> ZZ) simultaneously the middle part(3 digits '800' as per format) will increase each time the first 2 digit increases.

As an example - Username-- AA8001,Username:- AA8002,Username:-AA8003,Username:-AA8004--------Username:-AA8000

Next Sequence would be Username:- AB8011,Username:- AB8012------>Username:- AB8010 We also need information how we can store the existing table because at time of creation we need to check username for Uniqueness.

With Regards,

Siraj Molla

4 REPLIES 4

adarshk
Saviynt Employee
Saviynt Employee

KrishnaGupta
New Contributor III
New Contributor III

You will not be able to achieve this complex logic through username generation rule, it can be achieved using preprocessor jar where you can write Java code to generate username based on this logic.

Sample java code :
https://docs-be.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Resources/Attachments/Connection...


Preprocessor documentation
https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter03-User-Management/User-Impo...


Regards,
Krishna Gupta
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi @KrishnaGupta ,

Please let me know if we use jar file for the logic then where we will upload the existing ID for doing iteration to generate the Unique ID which is already generated by the organization.

With Regards,

Siraj Molla

You can use jar file 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.