Saviynt Forums

sfinney · 01/11/2023

Hello,I am trying to create a rule for username generation that give first initial, last initial, 4 random numbers. I have tried the following: concat(substring(users.firstname,1,1),substring(users.lastname,1,1),FLOOR(RAND()*10000))this generates the...

sfinney · 01/11/2023

Hello,I am creating Advanced Query Username Generation Rule and my users.firstname is not returning the correct value. Instead of getting the user's first name, it returns the advanced query. My query is below and it will allways generate a name "c<L...

sfinney · 11/15/2022

Hi, I am working on the scenario below.I want customproperty2 to be equal to customproperty1 at the time of initial user creation. However, when users are updated later on I want customproperty2 to remain unchanged, and only customproperty1 should be...

sfinney · 01/30/2023

Here is a screenshot of the query.

sfinney · 01/30/2023

concat(substring(users.firstname,1,1),substring(users.lastname,1,1),FLOOR(RAND()*10000)) I tried multiple variations to get a random number 4 digit number. I also included screenshots of the username it generates.

sfinney · 01/11/2023

That fixed the issue, I think the advanced query didn't like the substring(employeeid,-4) I changed it to substring(employeeid,3,6) and it properly returned the first initial.

sfinney · 11/15/2022

I got it to work "UPDATE NEWUSERDATA N join currentusers U on N.username=U.username set N.customproperty2 = N.customproperty1 where U.customproperty2 is null", "UPDATE NEWUSERDATA N join currentusers U on N.username=U.username set N.customproperty2 =...

Online Status	Offline
Date Last Visited	‎01/24/2024 03:44 PM

Saviynt Forums

User Statistics

User Activity

RAND() - Username Generation Advanced Query

First Name Incorrect Value - Username Generation Advanced Querry

SAV File Preprocessor Query

Re: RAND() - Username Generation Advanced Query

Re: RAND() - Username Generation Advanced Query

Re: First Name Incorrect Value - Username Generation Advanced Querry

Re: SAV File Preprocessor Query

Re: SAV File Preprocessor Query