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

Duplicate ServiceNow Accounts Created for Archived Accounts.

samrat_dutta_5
New Contributor
New Contributor

Hi,
We have a procedure of changing the name of ServiceNow accounts from lets say abc.efg@company.com to ToArchive.abc.efg@company.com in a use case. But, after an account import, there is another duplicate account getting created with the new ToArchive name, although it has the same accountid. Need ideas to get the ToArchive account mapped to the correct account during import.
The ImportAccountEntJSON is
{
"showLogs": true,
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"successResponses": {
"statusCode": [
200,
201
]
},
"unsuccessResponses": {
"statusCode": [
400,
401,
404,
405,
500
]
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://domain.service-now.com/api/now/table/sys_user?sysparm_limit=100",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "result",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"acctLabels": {
"customproperty1": "PersonnelNumber"
},
"colsToPropsMap": {
"accountID": "sys_id~#~char",
"name": "email~#~char",
"CUSTOMPROPERTY7": "user_name~#~char",
"CUSTOMPROPERTY2": "last_name~#~char",
"customproperty3": "name~#~char",
"CUSTOMPROPERTY4": "first_name~#~char",
"status": "active~#~char",
"CUSTOMPROPERTY5": "u_employee_legacy_number~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${headers?.Link?.split(';')?.size()==5?headers?.Link?.split(';')[2]?.replace('rel=\"prev\",<', '')?.replace('>','')?.trim():headers?.Link?.split(';')?.size()==4 && headers?.Link?.split(';')[2].contains('rel=\"next\",<')?headers?.Link?.split(';')[1]?.replace('rel=\"first\",<', '')?.replace('>','')?.trim():null}"
}
}
}
}
},
"entitlementParams": {},
"acctEntParams": {}
}

[This post has been edited by a Moderator to remove sensitive information.]

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

Need ideas to get the ToArchive account mapped to the correct account 

Do you mean user ?


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

samrat_dutta_5
New Contributor
New Contributor

I want to restrict this duplicate account creation. When we run the import, I want Saviynt to detect that ToArchive.abc.efg@company.com is equal to abc.efg@company.com, because both have same accountID.

You can update correlation rule

user.email=replace(accounts.name,'ToArchive.','')


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