Map orphan account via analytics

[NID27]

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

[pmahalle]

@NID27 

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)

[Raghu]

@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://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...

https://forums.saviynt.com/t5/identity-governance/map-orphan-account-with-analytics/m-p/77115#M49161

[pmahalle]

HI @Raghu ,

It's working for me in 24.4. What do you mean by CSV upload? @NID27  Try with query above.

[rushikeshvartak]

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)