search

microsoftgraph / msgraph-sdk-powershell

Powershell SDK for Microsoft Graph
https://www.powershellgallery.com/packages/Microsoft.Graph
Other
712 stars 172 forks source link

Groups filter for property "hasMembersWithLicenseErrors" not working #2967

Closed joergrenn closed 1 month ago

joergrenn commented 1 month ago

Describe the bug

I am trying to get all groups with license assignment errors in the tenant: Get-MgGroup -CountVariable CountVar -Filter "hasMembersWithLicenseErrors eq true" -Property "id,displayName" -ConsistencyLevel eventual

This is even an example in MS learn: https://learn.microsoft.com/de-de/graph/api/group-list?view=graph-rest-1.0&tabs=powershell#example-2-get-a-filtered-list-of-groups-including-the-count-of-returned-objects

However the response is unsupported filter clause:

Get-MgGroup_List: Unsupported or invalid query filter clause specified for property 'hasMembersWithLicenseErrors' of resource 'Group'.

Expected behavior

Get all groups in the tenant with license assignment errors

How to reproduce

Execute Get-MgGroup -CountVariable CountVar -Filter "hasMembersWithLicenseErrors eq true" -Property "id,displayName" -ConsistencyLevel eventual

SDK Version

2.23.0

Latest version known to work for scenario above?

No response

Known Workarounds

No response

Debug output

Click to expand log ``` ```

Configuration

PSVersion 7.4.5 PSEdition Core GitCommitId 7.4.5 OS Darwin 23.6.0 Darwin Kernel Version 23.6.0: Wed Jul 31 20:48:52 PDT 2024; root:xnu-10063.141.1.700.5~1/RELEASE_ARM64_T6020 Platform Unix PSCompatibleVersions {1.0, 2.0, 3.0, 4.0…} PSRemotingProtocolVersion 2.3 SerializationVersion 1.1.0.1 WSManStackVersion 3.0

Other information

No response

timayabi2020 commented 1 month ago

Hi @joergrenn thank you for identifying and reporting this issue. I was able to reproduce this issue with both the PowerShell SDK and Graph Explorer tool and it appears to be a service issue. I also found out from here that the hasMembersWithLicenseErrors group property is among the properties supported with advanced queries.

image

Unfortunately, for API related issues/questions we are not best placed to give an answer. Kindly raise an issue here https://developer.microsoft.com/en-us/graph/support so that the API owner can respond to it.

joergrenn commented 1 month ago

Hallo @timayabi2020

Unfortunately, for API related issues/questions we are not best placed to give an answer. Kindly raise an issue here https://developer.microsoft.com/en-us/graph/support so that the API owner can respond to it.

I get that this is not the right place if it is a service issue and not an issue of the SDK, but directing me to the graph support is also not working. This is then a regular MS support case that will not be handled by the API owner. This only causes a lot of frustrations and wasted time because the support engineers are not equipped to handle these kinds of requests. I have no means to discuss this with an engineer who actually understands the issue. Also in the end this is all the same organisation Microsoft, there should be a way for you to pass this on internally without letting your customers jump throught hoops to get a bug fixed.