This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 55.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
I want to filter out all the service principals using odata filter query which belongs to microsoft tenant. I am using MG powershell module.
Get-MgServicePrincipal -Filter 'appOwnerOrganizationId eq f8cdef31-a31e-4b4a-93e4-5f571e91255a' -ConsistencyLevel eventual
Getting following error
You are missing the -CountVariable parameter ($count=true in the "raw" request). This works for me:
Get-MgServicePrincipal -Filter 'appOwnerOrganizationId eq f8cdef31-a31e-4b4a-93e4-5f571e91255a' -ConsistencyLevel eventual -CountVariable count
I use -CountVariable c and it still worked. Also using -Debug, I have realised it's MG module specific, not a part of API.
It failed again, when I used it with curl.
curl -H "Authorization: Bearer $ACCESS_TOKEN" 'https://graph.microsoft.com/v1.0/servicePrincipals?$filter=appOwnerOrganizationId%20ne%20f8cdef31-a31e-4b4a-93e4-5f571e91255a' -s
"Count" is just the name of the variable, you can use anything there, but the important part is to make sure you pass the -CountVariable parameter.
If you are doing a raw request, you need to pass the $count=true query parameter AND the cosnistencyLevel header. Check the documentation if you need more details: https://learn.microsoft.com/en-us/graph/aad-advanced-queries?tabs=http