Users web query
The Users web query displays Microsoft 365 user objects, including guest accounts, resource mailboxes, and shared mailboxes. Users' web query is included in the built-in Microsoft 365 container.
Users' web query settings
| Setting name | Description |
|---|---|
| Limit scope to this Azure AD Administrative Unit |
This setting defines the search query scope. To improve query performance, limit the scope to a specific OU. IMPORTANT: To test the rule configuration, limit the rule scope to an OU that contains test accounts or objects and use the Preview feature. |
| Query criteria | Query criteria are sent to the target platform with other query parameters to reduce the number of returned objects and may improve query performance. |
| Post-query filter |
To hide unwanted data based on criteria, not supported by the target system in the query criteria, set the filtering conditions here. Example: filter by the found object Distinguished Name. TIP: For optimal performance, use the Query criteria above to filter objects whenever possible. |
| Properties to display |
Each object property defined in this setting matches the column that will be displayed in the Web Portal for this web query. To display additional columns, add the required properties to the Properties to display list. |
| Default user state filter value |
Specify the filter value for the user state that will be selected by default in the Web Portal in the user web query filter.
|
| Default user type filter value |
Specify the filter value for the user type that will be selected by default in the Web Portal in the user web query filter.
|
| User account properties | |
| Account state |
Specify account state:
|
| User type |
Specify user type:
|
| Account sync status |
Specify account sync status:
|
| Modern MFA status |
Specify modern MFA status:
IMPORTANT: Due to the current nature of the Microsoft API that returns this information, users will be processed one by one by this MFA status post-filter. Expect 10 minutes of processing per every 300 returned users if this filter is enabled. Reduce the number of users by using query criteria to reduce the rule execution time. |
| Administrator role |
Specify administrator role:
|
| Date time properties | |
| Minimum account age (hours) | Specify the minimum account age for the Microsoft 365 user accounts. |
| Maximum account age (hours) | Specify the maximum account age for the Microsoft 365 user accounts. |
| Last Microsoft 365 sign in (days ago) |
Set a minimum number of days past since a user signs in to Microsoft 365. Use 0 to disable this check. NOTE: Using this parameter requires an Azure AD Premium P1/P2 license in the tenant. |
| Last password change (days ago) | Set a minimum number of days past since a user changed the password. |
| Last sync time (days ago) | Set a minimum number of days past the last sync time. |
| Extension Attributes | |
|
Extension attribute1 - Extension attrbute15 |
If you use Microsoft 365 extension attributes to store additional information for user accounts, you could select these attributes and map them to Other Attributes. Learn more in: How to add custom attributes to New Object and Object Properties wizards in Web Portal. |
| Mailbox and Licensing filters | |
| Mailbox type |
Specify mailbox type:
|
| Include licensed users |
Specify which users should be included:
|
| Filter by licenses |
You can filter users by assigned licenses and apps/services:
Also, you can add filtering by inheritance of assigned applications and services:
|
| Organization Properties | |
|
Specify organization properties for search. |
| Map to Text File | |
| Select data source |
Specify the text file to be imported. The […] (three dots) button allows the user to browse for the file and the Create/Edit button allows the creation or editing of the existing file in the built-in Data Source editor. |
| Separator used in file | Specify the separator used in the source CSV file. |
| Data source anchor attribute | Select a column in the data source that contains the attribute value for identifying and mapping a computer. |
| System anchor attribute | Specify user anchor attribute. |
| Other query settings | |
| System properties | List of properties required for this rule to be executed correctly. |
| Sort by | Sort result object list. |
| Limit result set |
The maximum number of users returned from Microsoft 365 by default is 2000. TIP: It is possible to change the default value in Microsoft 365 extension settings. |
| MS Graph query condition (OData) |
By default, Query criteria are used. But when the MS Graph query condition is specified, it overrides the Query criteria setting. See this article for additional information: How to use Query Builder dialog for Query Criteria and Filter rule settings. |
| MS Graph advanced queries | Enables consistency level eventually which uses an index that might not be up-to-date with recent changes to the object. |
| Default number of objects to show | Select the number of objects to display in the Users web query in the Web Portal.
By default, the global Web Portal setting from the Web Portal Customization > Default number of objects to show is used. Learn more in: Web Portal settings. |
| Initialization script | |
| Initialization script |
Usually, rules use query criteria to limit the query search scope. It improves the performance of the executed rule. Due to the PowerShell limitations, it is not possible to use calculated expressions in query criteria. That is the point where the initialization script can help. You can initialize a global variable in this setting and then use it in query criteria. IMPORTANT: To use a variable, declared in the initialization script, in the query scope, it must be global: Example: Update AD users, created in the last ten days.
|
Web Actions tab
For details review the following article: How to add, remove or re-arrange Web actions within a Web Query.
Output Section
This section defines the output format of this rule.
To get more information about this section, please see the Rule Output section article.
Change History
| Version | Notes |
|---|---|
| 11.1.0 | The Users web query has been updated with new settings. |
| 10.3.0 |
|
| 8.2.0 | MS Graph advanced queries setting is added. |
| 7.4.0 | Active Users web query is renamed to Users web query. |
| 7.2.0 | The Limit scope to this Azure AD Administrative Unit setting is added. |
Comments
0 comments
Please sign in to leave a comment.