TeamsUserActivityUserDetail
Provides detailed insights into user interactions in Microsoft Teams, including chat messages sent, meetings attended, and file collaboration. It supports productivity assessments and adoption tracking.
Select
The driver 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 driver.
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 TeamsUserActivityUserDetail WHERE Period = 'D7' SELECT * FROM TeamsUserActivityUserDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date when the Microsoft Teams user activity report was last refreshed. Represents the most recent day for which activity metrics are available. |
| UserId | String | The unique identifier for the user in Microsoft 365. Used internally to associate Teams activity with the user's account. |
| UserPrincipalName | String | The user principal name (UPN), typically in email format, that uniquely identifies the user within the Microsoft 365 tenant. |
| LastActivityDate | Date | The most recent date the user performed any measurable activity in Teams, including messaging, calls, or meetings. |
| IsDeleted | Boolean | Indicates whether the user account has been deleted from the directory. A value of true means the user is no longer active. |
| DeletedDate | Date | The date on which the user's account was deleted, if applicable. Empty if the user is still active. |
| AssignedProducts | String | A comma-separated list of Microsoft services or product licenses assigned to the user. May include Teams, Exchange Online, SharePoint, and others. |
| TeamChatMessageCount | Integer | The total number of messages the user posted in standard or public Teams channels during the reporting period. |
| PrivateChatMessageCount | Integer | The total number of messages the user sent in private one-on-one or group chats within Teams. |
| CallCount | Integer | The number of peer-to-peer or group voice/video calls made or received by the user in Teams. |
| MeetingCount | Integer | The total number of Teams meetings the user participated in, regardless of whether they were the organizer or attendee. |
| MeetingsOrganizedCount | Integer | The number of Teams meetings the user scheduled or hosted during the reporting period. |
| MeetingsAttendedCount | Integer | The number of Teams meetings the user joined as a participant during the reporting window. |
| AdHocMeetingsOrganizedCount | Integer | The number of ad hoc (unscheduled) Teams meetings the user initiated during the reporting period. |
| AdHocMeetingsAttendedCount | Integer | The number of ad hoc Teams meetings the user joined during the reporting period. |
| ScheduledOnetimeMeetingsOrganizedCount | Integer | The number of scheduled one-time Teams meetings the user organized. |
| ScheduledOnetimeMeetingsAttendedCount | Integer | The number of scheduled one-time Teams meetings the user attended. |
| ScheduledRecurringMeetingsOrganizedCount | Integer | The number of scheduled recurring Teams meetings the user organized, such as weekly syncs or monthly reviews. |
| ScheduledRecurringMeetingsAttendedCount | Integer | The number of scheduled recurring Teams meetings the user attended. |
| AudioDuration | String | The total amount of time the user spent in Teams meetings or calls with audio, displayed in a formatted string (for example, 01:23:45). |
| VideoDuration | String | The total amount of time the user was engaged in video sessions during Teams meetings or calls, displayed as a formatted string. |
| ScreenShareDuration | String | The total amount of time the user shared their screen during Teams meetings or calls, displayed as a formatted string. |
| AudioDurationInSeconds | Integer | The duration of all audio sessions for the user, measured in seconds. |
| VideoDurationInSeconds | Integer | The duration of all video sessions for the user, measured in seconds. |
| ScreenShareDurationInSeconds | Integer | The duration of screen sharing activity by the user, measured in seconds. |
| HasOtherAction | String | Indicates whether the user performed other Teams-related actions that are not explicitly tracked in the message, call, or meeting categories. |
| UrgentMessages | Integer | The number of urgent messages the user sent. Urgent messages notify recipients repeatedly for increased visibility. |
| PostMessages | Integer | The number of new posts the user created in Teams channels. This excludes replies to existing threads. |
| TenantDisplayName | String | The display name of the Microsoft 365 tenant to which the user belongs. Useful in multi-tenant environments for identifying user origin. |
| SharedChannelTenantDisplayNames | String | A comma-separated list of tenant display names with which the user has participated in shared channel communications. |
| ReplyMessages | Integer | The number of reply messages the user posted in response to existing messages in Teams channels. |
| IsLicensed | String | Indicates whether the user has a Teams license assigned. A non-empty value signifies license presence. |
| ReportPeriod | Integer | The duration, in days, over which activity data is aggregated. Common values are 7, 30, 90, and 180. |
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 | Specifies the standardized aggregation window for the report. Valid 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 date (in YYYYMMDD format) for which user activity is reported. Must fall within the past 30 days due to data retention limits. |