Office365ActivationsUserDetail
Shows which users have successfully activated Office 365 across devices, including installation date and license status. This is useful for license compliance tracking and deployment validation.
Select
The add-in uses the Microsoft Exchange API to process WHERE clause conditions. The rest of the filter is executed client-side in the add-in.
For example, the following query is processed server-side:
SELECT * FROM Office365ActivationsUserDetail
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date on which the Office 365 activation report was last refreshed, indicating the freshness of the dataset. |
| UserPrincipalName | String | The unique user identifier in the form of an email address, used to log into Office 365 services. |
| DisplayName | String | The full display name associated with the user account that has Office 365 activations. |
| ProductType | String | The specific Office 365 product or license type assigned to the user, such as Office 365 E3 or Office 365 Business Premium. |
| LastActivatedDate | Date | The most recent date on which the user activated an Office 365 application on any device. |
| Windows | Integer | The total number of times Office 365 has been activated by the user on Windows devices. |
| Mac | Integer | The total number of times Office 365 has been activated by the user on Mac devices. |
| Windows10Mobile | Integer | The total number of times Office 365 has been activated by the user on Windows 10 Mobile devices. |
| IOS | Integer | The total number of times Office 365 has been activated by the user on iOS devices such as iPhones or iPads. |
| Android | Integer | The total number of times Office 365 has been activated by the user on Android devices such as smartphones or tablets. |
| ActivatedOnSharedComputer | Boolean | Indicates whether the user has activated Office 365 on a shared computer environment, such as in a lab or kiosk setup. |