Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/22/2024 03:01 AM
I have integrated Saviynt with SonarQube.
One of the users had 2 accounts in SonarQube. The account import job imported both the accounts(account name is same but accountId(login attribute in SonarQube) is different). Both accounts are showing as active under SonarQube endpoint in Saviynt.
Next admin deleted one of the accounts in SonarQube system but Saviynt still shows both accounts as active even though account import job is running successfully.
Now when I try to raise access request in Saviynt using any one of the accounts, it uses accountId associated with the account already disabled in SonarQube and provisioning task fails with error "User not found in SonarQube".
How can I manually disable the unwanted account in Saviynt ??
Solved! Go to Solution.
10/22/2024 03:05 AM
@Kaushik use enhanced query to change the status and name of the account which has been deleted in target application.
10/22/2024 03:09 AM
Thanks for prompt response.
Can you please share sample query how to change status.
10/22/2024 03:16 AM
@Kaushik sample
SELECT
CONCAT(ac.name, '-Deleted on-', SYSDATE()) AS accounts__name,
'SUSPENDED FROM IMPORT SERVICE' AS accounts__status,
ac.accountkey AS accounts__primarykey FROM accounts where accountkey = '1'
10/22/2024 03:44 AM
You have specified a select query. I am able to identify the unwanted account using following select query:
select accountkey,accountid,name,status from accounts where endpointkey in (select endpointkey from endpoints where endpointname='EP_SonarQube') and accountid= 'zzzz'
But how to change the status for this account in Saviynt? What is update query? Is update even allowed??
10/22/2024 03:55 AM - edited 10/22/2024 03:55 AM
@Kaushik enhanced query job will use a select query.
Create a enhanced query job from job control panel.
And use the above query to change status.
10/22/2024 06:24 AM - edited 10/22/2024 06:25 AM
Use enhanced query job from job control panel and use below query
SELECT
CONCAT(ac.name, '-Deleted on-', SYSDATE()) AS accounts__name,
'SUSPENDED FROM IMPORT SERVICE' AS accounts__status,
ac.accountkey AS accounts__primarykey
FROM
accounts ac
JOIN
endpoints ep ON ac.endpointkey = ep.endpointkey
WHERE
ep.endpointname = 'EP_SonarQube'
AND ac.accountid = 'zzzz' limit 1
sample video on how to create EQ job