Office 365 Users and Guests Inactive rule

Query criteria

Query criteria are sent with the query and may improve query performance.

User sync status

Specify user sync status.

User type

Specify user type: Guest, Member, or All user types.

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.

Last Microsoft 365 service access (days ago)

Set a number of days past since the last Office 365 service access.

Minimum license assignment age (days)

Set a minimum number of days past since the license assignment to avoid counting new users as inactive. Use 0 to ignore the license assignment date.

Other Query Settings

Properties to display

To display additional properties for each object found by the query, add those properties to the list.

System properties

List of properties required for this rule to be executed correctly.

Post-query filter

To hide unwanted data based on criteria set the filtering conditions here.

Example: filter by the found object Distinguished Name.

Sort by

Sort result object list.

Limit result set

The maximum number of objects returned from Office 365. The default value is taken from Maximum returned results setting on HOME > CONFIGURATION > Microsoft Office 365 settings. 

MS Graph query condition (OData)

By default Query criteria is used. But when it is specified, it overrides the Query criteria setting.

Initialization script

Usually, rules use query criteria to limit the query search scope. It improves the performance of the executed rule.

Due to PowerShell limitations, it is not possible to use calculated expressions in query criteria. That is the point where initialization script can help. You can initialize a global variable in this setting and then use it in query criteria. 

MS Graph advanced queries

Enables consistency level eventual which uses an index that might not be up-to-date with recent changes to the object.