I'm trying to find a user in Entra by its onPremisesSamAccountName with MS Graph API. I tried couple approaches but both failed:

• using $filter=onPremisesSamAccountName eq 'den' which returned 0 user found
• using $search="onPremisesSamAccountName:den which returns several users, but no actual den among them

UPDATE: both queries have ConsistencyLevel header set to Eventual and also $count query parameter set to true.

What can be possibly wrong in those requests or how to approach the troubleshooting in my case?

I'm trying to find a user in Entra by its onPremisesSamAccountName with MS Graph API. I tried couple approaches but both failed:

• using $filter=onPremisesSamAccountName eq 'den' which returned 0 user found
• using $search="onPremisesSamAccountName:den which returns several users, but no actual den among them

UPDATE: both queries have ConsistencyLevel header set to Eventual and also $count query parameter set to true.

What can be possibly wrong in those requests or how to approach the troubleshooting in my case?

• azure
• microsoft-graph-api
• microsoft-entra-id

• Could you try by adding Header to ConsistencyLevel = Eventual, Refer this Microsoft QnA – Pratik Jadhav Commented 23 hours ago
• Please check below answer and let me know it works for you or not! @Philipp – Pratik Jadhav Commented 22 hours ago

1 Answer 1

To find a user in Entra by its onPremisesSamAccountName with MS Graph API.

NOTE: $filter and $search query parameter is only supported when the ConsistencyLevel header is set to Eventual and the $count parameter is included. For more details Refer this Microsoft QnA Answer.

To add support for additional query capabilities on some properties(like onPremisesSamAccountName), those properties might be indexed in a separate store. This separate indexing improves query performance. For More details, Refer this MsDocument

Use below endpoint by using $filter parameter:

Header:
ConsistencyLevel: Eventual

GET https://graph.microsoft/v1.0/users?$filter=onPremisesSamAccountName eq 'den'&$count=true

Use below endpoint by using $search parameter:

Header:
ConsistencyLevel: Eventual

GET https://graph.microsoft/v1.0/users?$search="onPremisesSamAccountName:den"&$count=true

Reference:

Advanced query capabilities on Microsoft Entra ID for Users Properties