Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/03/2024 01:41 AM
Hi,
I am trying to map orphan accounts via analytics. I have written a below query but gives error.
SELECT accountkey as 'acctkey' , name from accounts where status not in (1,'Active','Manually Provisioned') and endpointkey=8 and accountkey not in (select accountkey from user_accounts)
Thanks
Nidhi Sharma
06/03/2024 02:27 AM - edited 06/03/2024 02:28 AM
Looks like query is correct but can you try below once, by removing single quotes
SELECT accountkey as acctkey, name from accounts where status not in (1,'Active','Manually Provisioned') and endpointkey=8 and accountkey not in (select accountkey from user_accounts)
06/03/2024 03:51 AM - edited 06/03/2024 03:55 AM
@NID27 we can't map orphan accoutns via analytics , based on csv file you upload
select a.name,a.accountkey as acctKey, endpointkey, 'disableAccount' as Default_Action_For_Analytics from accounts a where accountkey not in (select accountkey from user_accounts)
https://forums.saviynt.com/t5/identity-governance/map-orphan-account-with-analytics/m-p/77115#M49161
06/03/2024 04:08 AM
HI @Raghu ,
It's working for me in 24.4. What do you mean by CSV upload? @NID27 Try with query above.
06/03/2024 11:46 AM
K is small in your query
SELECT accountkey as 'acctKey' , name from accounts where status not in (1,'Active','Manually Provisioned') and endpointkey=8 and accountkey not in (select accountkey from user_accounts)