SkypeForBusinessDeviceUsageUserDetail
Shows the types of devices used to access Skype for Business, helping IT teams understand client distribution and identify legacy platforms.
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 SkypeForBusinessDeviceUsageUserDetail WHERE Period = 'D7' SELECT * FROM SkypeForBusinessDeviceUsageUserDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date on which the Skype for Business device usage report was last refreshed. Indicates the latest available data snapshot. |
| UserPrincipalName | String | The unique user principal name (UPN) associated with the individual whose device usage is being reported. Typically formatted as an email address. |
| LastActivityDate | Date | The most recent date on which the user accessed Skype for Business from any device. This helps track recent engagement levels. |
| UsedWindows | String | Indicates whether the user accessed Skype for Business using a Windows-based device during the reporting period. A non-empty value confirms usage. |
| UsedWindowsPhone | String | Indicates whether the user accessed Skype for Business via a Windows Phone device during the reporting period. |
| UsedAndroidPhone | String | Indicates whether the user accessed Skype for Business from an Android phone. A non-empty value implies activity on the platform. |
| UsediPhone | String | Indicates whether the user accessed Skype for Business on an iPhone device during the report period. |
| UsediPad | String | Indicates whether the user accessed Skype for Business on an iPad. Presence of data suggests usage of the platform on iOS tablets. |
| ReportPeriod | Integer | The number of days covered by the device usage report. Common values include 7, 30, 90, and 180, representing how far back the data is aggregated. |
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 time range used for aggregating report data. Acceptable 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 calendar date (in YYYY-MM-DD format) for which the device usage data is being requested. Only dates from the past 30 days are supported in this report. |