How to prevent creating a user profile from SAV schema based import file. Only updating attributes

[Miko]

Hello Saviynt Team,

We have requirement only to update Saviynt user profile from import csv file. We need to prevent creating a user using schema based import file. How can we achieve this on .SAV file?

#USER_NOT_IN_FILE_ACTION=NOACTION
#FILENAME=xxx
#DELIMITER=,
#SKIP_NUMBER_OF_LINES=1
#ZERODAYPROVISIONING=TRUE
#userReconcillationField=UserName
#GENERATESYSTEMUSERNAME=FALSE
#GENERATEEMAIL=TRUE
#EMAILTEMPLATE="Email Template Name"
#CHECKRULES=TRUE

Thanks,

[nimitdave]

@Miko , you can try by leveraging the inline pre-processor to delete the records in newusers not present in currentusers table.

[Miko]

Hi Nimitdave,

Can you please provide me sample inline pre-processor script that I can use?

Thanks,

[nimitdave · Accepted solution]

@Miko , pls see if below helps:

{
"ADDITIONALTABLES": {
"USERS": "SELECT USERNAME,EMPLOYEEID FROM USERS"
},
"COMPUTEDCOLUMNS": [
"title"
],
"PREPROCESSQUERIES": [
"delete from NEWUSERDATA where EMPLOYEEID not in (select EMPLOYEEID from CURRENTUSERS)"
]
}

[Miko]

Thank you. This is help full