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 cmdlet uses the Microsoft Exchange API to process WHERE clause conditions. The rest of the filter is executed client-side in the cmdlet.
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. |