YammerDeviceUsageUserDetail
Offers insights into how users are accessing Yammer by device type (for example, mobile, desktop, web), enabling device usage analysis at an individual user level.
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 YammerDeviceUsageUserDetail WHERE Period = 'D7' SELECT * FROM YammerDeviceUsageUserDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date on which the Yammer device usage report was last refreshed. Indicates the most recent snapshot of device usage data available. |
| UserPrincipalName | String | The user principal name (UPN) associated with the Yammer account. Typically in the format of an email address and used for uniquely identifying the user. |
| DisplayName | String | The display name of the user as shown in Yammer. This name appears in conversations and user listings. |
| UserState | String | Indicates the current state of the user account in Yammer. Common values include Active, Blocked, or Deleted. |
| StateChangeDate | Date | The date on which the user's Yammer account status last changed, such as becoming active, blocked, or deleted. |
| LastActivityDate | String | The most recent date the user accessed Yammer using any device. This helps determine user engagement across platforms. |
| UsedWeb | String | Indicates whether the user accessed Yammer through a web browser during the reporting period. A non-empty value confirms activity. |
| UsedWindowsPhone | String | Indicates whether the user accessed Yammer from a Windows Phone. Presence of data confirms at least one session on this device type. |
| UsedAndroidPhone | String | Indicates whether the user accessed Yammer using an Android phone during the reporting period. |
| UsediPhone | String | Indicates whether the user accessed Yammer on an iPhone device. A value here reflects usage on iOS smartphones. |
| UsediPad | String | Indicates whether the user accessed Yammer on an iPad. This field helps track engagement on larger mobile iOS devices. |
| UsedOthers | String | Captures usage from other platforms not explicitly listed, such as desktop apps or older/unsupported devices. |
| ReportPeriod | Integer | The number of days for which Yammer device usage is reported. 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 | Specifies the standardized aggregation window for the report. Valid values are D7, D30, D90, and D180, where Dn indicates the duration in days.
The allowed values are D7, D30, D90, D180. The default value is D7. |
| Date | Date | The specific calendar date (formatted as YYYY-MM-DD) for which device usage data is requested. This must be within the last 30 days, based on data retention policies. |