TeamsDeviceUsageUserDetail
Reveals which device types (desktop, mobile, web) are used by each user to access Microsoft Teams. This is useful for analyzing platform preference and guiding hardware planning.
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 TeamsDeviceUsageUserDetail WHERE Period = 'D7' SELECT * FROM TeamsDeviceUsageUserDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date on which the Microsoft Teams device usage report was last refreshed. This represents the most recent date for which usage data is available. |
| UserId | String | A unique identifier assigned to the user within Microsoft 365. Used internally to associate activity data with the correct user profile. |
| UserPrincipalName | String | The user principal name (UPN) of the Teams user. This is typically the user's login ID in the form of an email address. |
| LastActivityDate | Date | The most recent date on which the user accessed Microsoft Teams using any supported device. Indicates their latest activity across platforms. |
| IsDeleted | Boolean | Indicates whether the user's Teams account has been deleted. A value of true signifies the user is no longer active in the directory. |
| DeletedDate | Date | The date on which the user's Teams account was deleted, if applicable. Empty for users who are still active. |
| UsedWeb | String | Indicates whether the user accessed Microsoft Teams through a web browser. A non-empty value confirms browser-based usage. |
| UsedWindowsPhone | String | Indicates whether the user accessed Microsoft Teams using a Windows Phone. Presence of a value confirms usage from this device type. |
| UsedIOS | String | Indicates whether the user accessed Microsoft Teams from an iOS device such as an iPhone or iPad. |
| UsedMac | String | Indicates whether the user accessed Microsoft Teams on a macOS device. Usage is tracked if any Teams activity occurred on a Mac computer. |
| UsedAndroidPhone | String | Indicates whether the user accessed Microsoft Teams using an Android phone. Usage is tracked when Teams is accessed on Android devices. |
| UsedWindows | String | Indicates whether the user accessed Microsoft Teams from a Windows device, such as a laptop or desktop PC. |
| UsedChromeOS | String | Indicates whether the user accessed Microsoft Teams from a Chrome OS device. Typically includes Chromebooks running the Teams web or Android app. |
| UsedLinux | String | Indicates whether the user accessed Microsoft Teams on a Linux-based operating system. Teams can be accessed via web browser or Linux-compatible apps. |
| IsLicensed | String | Indicates whether the user has been assigned a valid Microsoft Teams license. A non-empty value suggests that the user has a Teams-compatible subscription. |
| ReportPeriod | Integer | The number of days covered by the device usage report. Common values are 7, 30, 90, and 180, representing how far back activity is tracked. |
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 aggregation interval for the report data. Supported values include 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 (formatted as YYYY-MM-DD) for which device usage data is being returned. Must be within the past 28 days, as this is the retention limit. |