Specify Active Directory group DistinguishedName. The hybrid Microsoft 365 Users that are members of an AD group will be displayed in the report.

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.

Cayosoft Administrator queries the SignInActivity user property to get the last sign-in timestamp. Refer to the following Microsoft article for additional information: signInActivity resource type | Microsoft Learn.

Set a number of days since the last Microsoft 365 service access. Cayosoft Administrator references data collected in Microsoft 365 reports. Refer to the following Microsoft article for additional information: Microsoft 365 Reports in the admin center | Microsoft Learn.

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. Cayosoft Administrator queries the AssignedPlan user property to calculate the assignment age. Refer to the following Microsoft article for additional information: assignedPlan resource type | Microsoft Learn.

Other Query Settings

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.

To add extension attribute 1 that is synchronized from AD, you need to use a value like:

"OnPremisesExtensionAttributes/extensionAttribute1~Extension Attribute 1"

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

To hide unwanted data based on criteria, not supported by the Microsoft 365 query criteria above, set the filtering conditions here.

TIP: For optimal performance, use the Query criteria above to filter objects whenever possible.

Sort result object list.

This setting is used to optimize performance by limiting the number of objects returned by the Microsoft Graph API.

Unlike query criteria, any post-filters on the returned objects are applied after they are returned, which means that the final set of returned objects could be less than the number configured here despite these objects existing in the source system.