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
