Get Users With More Than One Account in the authoritative source like Workday

[kalyannambi2010 (Kalyana Chakravarthi Nambi)]

Hi Team,

We would like to search in IDN to get users with more than one account in the authoritative source like Workday and restrtict for only one source.

Thanks
Kalyan

[rajeshs (Rajesh Kumar)]

I don’t think the above can be done via Search. The below link provides us the explanation which can be helpful. Hope it helps

Get Users With More Than One Account in the Same Source

The query above will only work when limiting by authoritative source. The reason for this is that the top level source object on an identity object is that identity’s authoritative source. If you need to restrict your query to a non-authoritative source, then you will need to use the following query. { "query": { "query": "@accounts(source.id:2c918088814e6a610181686b56977fa8)" }, "indices": [ "identities" ], "aggregationsDsl": { "accounts": { …

[kalyannambi2010 (Kalyana Chakravarthi Nambi)]

Hi Rajesh Kumar,

Thank you for your reply and I have already tried to execute this for authoritative source but I was getting error using Postman.

Thanks
Kalyan

[colin_mckibben]

The solution that @rajeshs linked above should work for your use case. What error are you receiving?

[rajeshs (Rajesh Kumar)]

@kalyannambi2010 Can you please post the error message ?

[kalyannambi2010 (Kalyana Chakravarthi Nambi)]

Hi Colin and Rajesh,

Looks like the query is working now and we are testing the query with our data. I will reach out to you again if I face any issues.

Thanks
Kalyan