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

Multiple DR accounts are not getting synced to Saviynt

Nehau
New Contributor
New Contributor

Hi 

We are trying to update list of multiple service accounts in Saviynt through a CSV file under accounts tab to map the Custom property 56 that contains another account name information.

Under account ID, we are trying to add more service accounts.

There is a scheduled job that runs in a timely manner however still the custom property 56 is not getting mapped in Saviynt.

Please help with your suggestions here.

Thank you,

Neha Upadhyay

11 REPLIES 11

rushikeshvartak
All-Star
All-Star

Can you share import sheet


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

Nehau
New Contributor
New Contributor

Hi Rushikesh,

Please find the attached sample file.

Regards,

Neha Upadhyay

Nehau
New Contributor
New Contributor

Hi Rushikesh,

Greetings!

Could you please let me know if you got any chance to look in this issue and if there are any updates to be shared.

Regards,

Neha Upadhyay

I don't find any CP56 column


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

prafullgoyal
Saviynt Employee
Saviynt Employee

@NehauHave you attempted to enter CP56 on the import sheet?

If you find the above response useful, Kindly Mark it as "Accept As Solution".

VenkatN
New Contributor
New Contributor

Hello Rishikesh and Goyal,

We are following the below process to update CP56 for the service accounts.

1. we are editing the raw file make it as above attached "test_file.csv" file to upload under Accounts in Saviynt production environment. import process is documented and attached here.

2.After uploading the data, we have one scheduled custom query job to update DR account ID under CP56 for the accounts in the csv file. please see the query below for the custom query job.

"update accounts adA
INNER JOIN (select a.name as AccName , group_concat(da.name) as DeviationID from accounts da
INNER JOIN accounts a ON da.displayname LIKE concat('%#', a.name , '#%')
INNER JOIN endpoints ea ON a.endpointkey = ea.endpointkey
INNER JOIN endpoints eda ON da.endpointkey = eda.endpointkey
and ea.endpointname = 'Active Directory'
and eda.endpointname = 'CAR_Deviation_Endpoint'
group by a.name) devDetails ON devDetails.AccName = adA.name
INNER JOIN endpoints adAEP ON adA.endpointkey = adAEP.endpointkey
and adAEP.endpointname = 'Active Directory'
set adA.customproperty56 = devDetails.DeviationID;"

3. We are mapping single DR id with multiple service accounts separates with # symbol, example #SA_abc1#SA_abc2#. in the csv file Account name is DR id and account ID, display name contains multiple service accounts separated as #SA_abc1#SA_abc2#.

4. Same DR id we are updating for SA_abc1 and SA_abc2 under customproperty56 by using above custom query. 

initially DR id is updating as expected for the service accounts under CP56 which we used update in the csv file because, we have few accounts are there in account id for single DR id. now the account is increased. we are following the same procedure and now it is not working as expected. DR id is not updating for the service accounts.

Kindly check it and help us to resolve the issue.

 

Regards,

Venkat

 

Nehau
New Contributor
New Contributor

Hi Rushikesh/Prafful,

Could you please let me know if there is any next update on this issue.

 

Regards,

Neha

prafullgoyal
Saviynt Employee
Saviynt Employee

@Nehau , How many accounts are you currently processing? Could you please supply the select result of your update query?

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Nehau
New Contributor
New Contributor

Hi Prafull,

We are processing more than 60 accounts in a single row and that has more than 1000 characters.

 

Regards,

Neha 

 

Nehau
New Contributor
New Contributor

Hi Prafull,

We are following the below process to update CP56 for the service accounts.

1. we are editing the raw file make it as above attached "test_file.csv" file to upload under Accounts in Saviynt production environment. import process is documented and attached here.

2.After uploading the data, we have one scheduled custom query job to update DR account ID under CP56 for the accounts in the csv file. please see the query below for the custom query job.

"update accounts adA
INNER JOIN (select a.name as AccName , group_concat(da.name) as DeviationID from accounts da
INNER JOIN accounts a ON da.displayname LIKE concat('%#', a.name , '#%')
INNER JOIN endpoints ea ON a.endpointkey = ea.endpointkey
INNER JOIN endpoints eda ON da.endpointkey = eda.endpointkey
and ea.endpointname = 'Active Directory'
and eda.endpointname = 'CAR_Deviation_Endpoint'
group by a.name) devDetails ON devDetails.AccName = adA.name
INNER JOIN endpoints adAEP ON adA.endpointkey = adAEP.endpointkey
and adAEP.endpointname = 'Active Directory'
set adA.customproperty56 = devDetails.DeviationID;"

3. We are mapping single DR id with multiple service accounts separates with # symbol, example #SA_abc1#SA_abc2#. in the csv file Account name is DR id and account ID, display name contains multiple service accounts separated as #SA_abc1#SA_abc2#.

4. Same DR id we are updating for SA_abc1 and SA_abc2 under customproperty56 by using above custom query. 

initially DR id is updating as expected for the service accounts under CP56 which we used update in the csv file because, we have few accounts are there in account id for single DR id. now the account is increased. we are following the same procedure and now it is not working as expected. DR id is not updating for the service accounts.

 

The attribute where we are storing the SA names has the limitation of 255 characters hence the CP56 is getting updated only for first few accounts rather than rest all.

Kindly check it and help us to resolve the issue.

Regards,

Neha

Nehau
New Contributor
New Contributor

@prafullgoyal @rushikeshvartak 

Hi Prafull and Rushikesh,

Could you please check the details in the notes above and help us with to fix the issue.

The number of account varies every time however it must be approximately around 300. Please let us know if any more questions.

Regards,

Neha