Office365ActiveUserDetail
Reports on user-level activity across Office 365 services (Exchange, Teams, SharePoint, etc.). It includes the last activity date per service to help identify inactive or underutilized accounts.
Select
The connector uses the Microsoft Exchange API to process WHERE clause conditions built with the following columns and operators:
- Period supports the '=' operator.
- Date supports the '=' operator.
The rest of the filter is executed client-side in the connector.
At a minimum, a Date or Period column is required to get the report data. By default, the driver makes a request of the period as D7 if no filter is specified.
For example, the following query is processed server-side:
SELECT * FROM Office365ActiveUserDetail WHERE Period = 'D7' SELECT * FROM Office365ActiveUserDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date when the Office 365 active user report was last refreshed, reflecting the most recent data available. |
| UserPrincipalName | String | The unique user sign-in identifier in the format of an email address (for example, [email protected]) used across Microsoft 365 services. |
| DisplayName | String | The full display name of the user as configured in Azure Active Directory or Exchange Online. |
| IsDeleted | Boolean | Indicates whether the user account is marked as deleted within the Office 365 directory at the time of the report. |
| DeletedDate | Date | The date when the user account was deleted from the Office 365 environment, if applicable. |
| HasExchangeLicense | Boolean | True if the user has been assigned a license that includes Exchange Online for email and calendar services. |
| HasOneDriveLicense | Boolean | True if the user has an active license for OneDrive for Business, enabling personal cloud storage. |
| HasSharePointLicense | Boolean | True if the user has been assigned a SharePoint Online license, allowing access to team sites and document libraries. |
| HasSkypeForBusinessLicense | Boolean | True if the user has a license for Skype for Business, supporting messaging, audio, and video communication features. |
| HasYammerLicense | Boolean | True if the user is licensed for Yammer, Microsoft's enterprise social networking platform. |
| HasTeamsLicense | Boolean | True if the user has been assigned a Microsoft Teams license for collaboration, chat, meetings, and file sharing. |
| ExchangeLastActivityDate | Date | The most recent date the user engaged with Exchange Online, such as sending or receiving email. |
| OneDriveLastActivityDate | Date | The most recent date the user accessed or modified content in OneDrive for Business. |
| SharePointLastActivityDate | Date | The most recent date the user accessed or interacted with content in SharePoint Online. |
| SkypeForBusinessLastActivityDate | Date | The last recorded activity date for the user on Skype for Business, including messages or calls. |
| YammerLastActivityDate | Date | The most recent date the user posted, liked, or engaged with content on Yammer. |
| TeamsLastActivityDate | Date | The last date of user activity on Microsoft Teams, including messages, meetings, or file interactions. |
| ExchangeLicenseAssignDate | Date | The date when the Exchange Online license was assigned to the user account. |
| OneDriveLicenseAssignDate | Date | The date when the OneDrive for Business license was assigned to the user account. |
| SharePointLicenseAssignDate | Date | The date on which the user was assigned a SharePoint license. This indicates the activation of SharePoint capabilities under their Office 365 subscription. |
| SkypeForBusinessLicenseAssignDate | Date | The date on which the user received an assigned license for Skype for Business. This enables the user to access communication and conferencing features of Skype for Business. |
| YammerLicenseAssignDate | Date | The date when the user was provisioned with a Yammer license, allowing access to the organization's Yammer enterprise social network. |
| TeamsLicenseAssignDate | Date | The date when the Microsoft Teams license was assigned to the user, enabling access to Teams collaboration, messaging, and meeting features. |
| AssignedProducts | String | A list of Office 365 products currently assigned to the user, such as Exchange, SharePoint, Teams, Yammer, or Skype for Business. Values are comma-separated without spaces. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Period | String | Defines the aggregation window for the report. Acceptable values include D7, D30, D90, and D180, where Dn represents the number of days, indicating reporting periods of 7, 30, 90, or 180 days.
The allowed values are D7, D30, D90, D180. The default value is D7. |
| Date | Date | The specific date for which activity data is retrieved in the format YYYY-MM-DD. Only dates within the last 30 days are supported, as the report is limited to a rolling 30-day period. |