Office365GroupsActivityDetail
Details the usage and engagement of Microsoft Exchange Groups, including counts of emails, posts, and file activities. This is useful for understanding collaborative group behavior over time.
Select
The provider 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 provider.
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 Office365GroupsActivityDetail WHERE Period = 'D7' SELECT * FROM Office365GroupsActivityDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date when the Office 365 usage report was last refreshed, indicating the most recent data available in the dataset. |
| GroupDisplayName | String | The display name of the Office 365 group, used to identify the group in user interfaces and reports. |
| IsDeleted | Boolean | Indicates whether the Office 365 group has been deleted. A value of true means the group is no longer active. |
| OwnerPrincipalName | String | The User Principal Name (UPN) of the person who owns the Office 365 group, typically the person who created or manages the group. |
| LastActivityDate | Date | The most recent date on which any member activity (email, file sharing, or communication) occurred within the Office 365 group. |
| GroupType | String | The classification of the Office 365 group, such as 'Unified' for Microsoft 365 Groups. This helps determine the services the group integrates with. |
| MemberCount | Integer | The total number of members currently associated with the Office 365 group. |
| ExternalMemberCount | String | The number of members in the group who are external to the organization, such as guests or partner users. |
| ExchangeReceivedEmailCount | String | The total number of emails received by the group's mailbox through Exchange Online during the reporting period. |
| SharePointActiveFileCount | String | The number of unique files that were viewed or edited by members in the group's connected SharePoint site. |
| YammerPostedMessageCount | String | The number of original messages posted in Yammer conversations by group members during the reporting period. |
| YammerReadMessageCount | String | The number of Yammer messages read by group members, showing group engagement levels on the Yammer platform. |
| YammerLikedMessageCount | String | The total number of Yammer messages liked by members of the group, indicating interaction and sentiment. |
| ExchangeMailboxTotalItemCount | String | The cumulative count of all items (emails, calendar events, or tasks) in the group's Exchange mailbox. |
| ExchangeMailboxStorageUsedByte | String | The total amount of storage, in bytes, currently used by the group's Exchange mailbox. |
| SharePointTotalFileCount | Integer | The total number of files stored in the SharePoint document libraries associated with the group. |
| SharePointSiteStorageUsedByte | Integer | The total storage consumption, in bytes, of the group's SharePoint site, including documents and site content. |
| GroupId | String | The unique identifier (GUID) for the Office 365 group, used internally across services to reference the group. |
| ReportPeriod | Integer | The duration, in days, that the report covers. Common values include 7, 30, 90, or 180 days. |
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 | The aggregation interval used for the report. Accepted values are D7, D30, D90, and D180, where Dn represents the number of days.
The allowed values are D7, D30, D90, D180. The default value is D7. |
| Date | Date | The specific calendar date (in YYYY-MM-DD format) representing when the activity snapshot was taken. Valid only for dates in the past 30 days. |