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(310.4, 30%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
I want to list users who have forceChangePasswordNextSignIn turned on.
https://learn.microsoft.com/en-us/graph/aad-advanced-queries states that passwordProfile/forceChangePasswordNextSignIn is filterable, but if I run
I get...
"error": {
"code": "Request_UnsupportedQuery",
"message": "Unsupported or invalid query filter clause specified for property 'forceChangePasswordNextSignIn' of resource 'User'." ...
You missed remark for the green-balled checkmark for forceChangePasswordNextSignIn, i.e.
The $filter operator requires advanced query parameters, which are:
ConsistencyLevel=eventual header
$count=true query string
![](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(300.8, 71%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
I'm using the following query with your recommendations but still get error.
curl --location 'https://graph.microsoft.com/v1.0/users?%24filter=passwordProfile%2FforceChangePasswordNextSignIn%20eq%20true&%24count=true' \
--header 'Authorization: aaa...' \
--header 'ConsistencyLevel: eventual'
Response body
{
"error": {
"code": "Request_UnsupportedQuery",
"message": "Unsupported or invalid query filter clause specified for property 'forceChangePasswordNextSignIn' of resource 'User'.",
"innerError": {
"date": "2023-04-14T14:04:49",
"request-id": "b63bca0d-d797-4a4c-af5d-4db717c6399d",
"client-request-id": "b63bca0d-d797-4a4c-af5d-4db717c6399d"
}
}
}
![](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(3.2, 82%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
I am so receiving the same error code while passing the required header and param in the query.