Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

How can we generate the full name of the user using the pre-existing firstname and lastname ?

anujapawar
New Contributor
New Contributor

How to generate any new attribute using the existing attribute values?

Ex: 1 . I need to generate the "display name" for John Doe as JohnD, how can we do this on saviynt ui?

Ex: 2 . Need to generate "full name" using the firstname and lastname which we have uploaded during csv file import. Also, I don't want to pass fullname as a column in csv file.

11 REPLIES 11

Manu269
All-Star
All-Star

@anujapawar refer this article for creating user via UI with DA usage

Configuring Create/Register User form in EIC - Saviynt Forums - 50744

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Raghu
All-Star
All-Star

Below query fetch data and upload:

 

1.

select concat(u.firstname,substring(u.lastname,1,2)) as 'Displayname' from users where u.userkey=''

2.

select firstname,lastname,concat(u.firstname,' ',u.lastname) as 'Fullname' from users u where u.userkey=''


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

In which field are we supposed to write this query on UI?

you create Dynamic attribute pass sql query like below

1.

select concat(u.firstname,substring(u.lastname,1,2)) as ID from users where u.userkey=${requestee}

2.

select firstname,lastname,concat(u.firstname,' ',u.lastname) as ID  from users u where u.userkey=${requestee}


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Is this the dynamic attribute field that you are referring to?  

If yes, can you help me fill these fields so as to get the required fullname attribute?

anujapawar_0-1710817837648.png

anujapawar_1-1710817887324.png

 

 

Use preprocessor in connection MODIFYUSERJSON

(Please find same in previous response)


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

I created the following dynamic attribute. Now where can I see the reflected changes?

Let me know if I am missing some parameters to be added!

anujapawar_0-1710824364548.png

 

Refer how to create dynamic attributes on documentation

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

rushikeshvartak
All-Star
All-Star
{
"ADDITIONALTABLES": {
"USERS": "SELECT USERNAME , MANAGER, OWNER, JOBCODE, STATUSKEY, CUSTOMPROPERTY13, CUSTOMPROPERTY64,DISPLAYNAME,OWNERONTERMINATE,FIRSTNAME,LASTNAME FROM USERS"
},
"COMPUTEDCOLUMNS": [
"CUSTOMPROPERTY64",
"CUSTOMPROPERTY8",
"OWNERONTERMINATE",
"DISPLAYNAME"
],
"PREPROCESSQUERIES": [
"ALTER TABLE NEWUSERDATA ADD INDEX `idx_USERNAME` (`USERNAME` ASC)",
"ALTER TABLE NEWUSERDATA ADD INDEX `idx_OWNER` (`OWNER` ASC)",
"ALTER TABLE NEWUSERDATA ADD INDEX `idx_JOBCODE` (`JOBCODE` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_USERNAME` (`USERNAME` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_JOBCODE` (`JOBCODE` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_OWNER` (`OWNER` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_MANAGER` (`MANAGER` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_STATUSKEY` (`STATUSKEY` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_DISPLAYNAME` (`DISPLAYNAME` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_OWNERONTERMINATE` (`OWNERONTERMINATE` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_FIRSTNAME` (`FIRSTNAME` ASC)",
"ALTER TABLE CURRENTUSERS ADD INDEX `idx_LASTNAME` (`LASTNAME` ASC)",
 
 
 
"UPDATE NEWUSERDATA NU1 INNER JOIN CURRENTUSERS CU1 ON CU1.USERNAME=NU1.USERNAME SET NU1.DISPLAYNAME = CONCAT(CU1.FIRSTNAME, ' ', CU1.LASTNAME)
 
]
}

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

PremMahadikar
All-Star
All-Star

Hi @anujapawar , Is this ask answered?

If not, Let me share this below;

As you have used/using .csv for importing users, we can achieve this during file import only. If the data is already in Saviynt. Please upload the data once again as one time activity to populate displayname and fullname

Admin -> Identity Repository -> users -> Actions: Upload user - add pre-processor config script after selecting file and other configs.

PremMahadikar_0-1710877724261.png

I have tested the below, and it works for me: Please try

{
   "ADDITIONALTABLES":{
      "USERS":"SELECT USERKEY,firstname, lastname,displayname,customproperty1 FROM USERS"
   },
   "COMPUTEDCOLUMNS":[
      "displayname",
      "customproperty1"
   ],
   "PREPROCESSQUERIES":[
      "UPDATE NEWUSERDATA SET displayname = CONCAT(firstname,substring(lastname,1,2))",
      "UPDATE NEWUSERDATA SET customproperty1 = CONCAT(firstname,',',lastname)"
   ]
}

Another sample JSON config from documentation link - Inline preprocessor

And how to use it - section COMPUTEDCOLUMNS, PREPROCESSQUERIES, ADDITIONALTABLES explained

Best practises of inline-preprocessor

 

If this solution answers your questions, please consider selecting Accept As Solution and hit kudos

Hi @PremMahadikar , 

Thank you for helping! It is finally working.