Get list of users without an specific endpoint

[Sushma]

Can someone please help with a query to get list of a particular zone users without a specific endpoint in Saviynt?

[dgandhi]

@Sushma 

Can you elaborate more on the ask?

[rushikeshvartak]

select distinct u.username from users u,accounts a, user_Accounts ua where u.userkey=ua.userkey and ua.accountkey=a.accountkey and u.customproperty1='ZONENAME'

Update highlighted as per your requirement

[Manu269 · Accepted solution]

@Sushma refer these articles :

Access assignment reports for the application acco... - Saviynt Forums - 28797

Solved: Reporting about Entitlement and Account List - Saviynt Forums - 49294

[Sushma]

Hi @dgandhi @Manu269 ,

I was able to extract orphan accounts for a specific endpoint.

Now we have to correlate to users, here the problem is automatically not getting correlated as email is incorrect(correlation rule-users email mapped to accounts email) and currently we can't correct the data due to some other issues.

I have tested manually correlating an account to a user and still account remains in user profile though not satisfying correlation rule and also after running full import.

So is there any way we can map these accounts to user through import?
I have tested with Analytics but there also manual effort needed.

[Manu269]

@Sushma check this of it helps :

Managing Orphan Accounts (saviyntcloud.com)

[Sushma]

Hi @Manu269 

These solutions don't work in this case, as we have bulk orphan accounts to map.