M365AppUserDetail
Returns detailed usage metrics showing which Microsoft Exchange apps (for example, Word, Excel, Outlook) and platforms (for example, Windows, Mac, web, mobile) users have accessed. Helps assess app adoption and usage trends.
Select
The cmdlet 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 cmdlet.
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 M365AppUserDetail WHERE Period = 'D7' SELECT * FROM M365AppUserDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date on which the M365 app usage report was last refreshed, indicating the currency of the data. |
| UserPrincipalName | String | The unique user principal name (UPN) that identifies the Microsoft 365 account of the user. |
| LastActivationDate | Date | The most recent date the user activated any Microsoft 365 app, typically through license activation or initial setup. |
| LastActivityDate | Date | The most recent date the user performed an activity in any Microsoft 365 app. |
| ReportPeriod | Integer | The number of days the report covers, used to define the reporting window for app usage. |
| Windows | String | Indicates whether the user has accessed any Microsoft 365 app on a Windows device during the reporting period. |
| Mac | String | Indicates whether the user has accessed any Microsoft 365 app on a macOS device during the reporting period. |
| Mobile | String | Indicates whether the user has accessed any Microsoft 365 app on a mobile device, such as iOS or Android. |
| Web | String | Indicates whether the user has accessed Microsoft 365 apps through a web browser. |
| Outlook | String | Indicates whether the user has used the Outlook app, regardless of platform. |
| Word | String | Indicates whether the user has used the Word app, regardless of platform. |
| Excel | String | Indicates whether the user has used the Excel app, regardless of platform. |
| PowerPoint | String | Indicates whether the user has used the PowerPoint app, regardless of platform. |
| OneNote | String | Indicates whether the user has used the OneNote app, regardless of platform. |
| Teams | String | Indicates whether the user has used Microsoft Teams, regardless of platform. |
| OutlookWindows | String | Indicates whether the user has specifically used the Outlook app on a Windows device. |
| WordWindows | String | Indicates whether the user has specifically used the Word app on a Windows device. |
| ExcelWindows | String | Indicates whether the user has specifically used the Excel app on a Windows device. |
| PowerPointWindows | String | Indicates whether the user has specifically used the PowerPoint app on a Windows device. |
| OneNoteWindows | String | Indicates whether the user has specifically used the OneNote app on a Windows device. |
| TeamsWindows | String | Indicates whether the user has accessed or used Microsoft Teams through the Windows desktop application during the reporting period. |
| OutlookMac | String | Indicates whether the user has accessed or used Microsoft Outlook through the macOS application during the reporting period. |
| WordMac | String | Indicates whether the user has accessed or used Microsoft Word through the macOS application during the reporting period. |
| ExcelMac | String | Indicates whether the user has accessed or used Microsoft Excel through the macOS application during the reporting period. |
| PowerPointMac | String | Indicates whether the user has accessed or used Microsoft PowerPoint through the macOS application during the reporting period. |
| OneNoteMac | String | Indicates whether the user has accessed or used Microsoft OneNote through the macOS application during the reporting period. |
| TeamsMac | String | Indicates whether the user has accessed or used Microsoft Teams through the macOS application during the reporting period. |
| OutlookMobile | String | Indicates whether the user has accessed or used Microsoft Outlook on a mobile device (iOS or Android) during the reporting period. |
| WordMobile | String | Indicates whether the user has accessed or used Microsoft Word on a mobile device (iOS or Android) during the reporting period. |
| ExcelMobile | String | Indicates whether the user has accessed or used Microsoft Excel on a mobile device (iOS or Android) during the reporting period. |
| PowerPointMobile | String | Indicates whether the user has accessed or used Microsoft PowerPoint on a mobile device (iOS or Android) during the reporting period. |
| OneNoteMobile | String | Indicates whether the user has accessed or used Microsoft OneNote on a mobile device (iOS or Android) during the reporting period. |
| TeamsMobile | String | Indicates whether the user has accessed or used Microsoft Teams on a mobile device (iOS or Android) during the reporting period. |
| OutlookWeb | String | Indicates whether the user has accessed or used Microsoft Outlook through a web browser (Outlook on the web) during the reporting period. |
| WordWeb | String | Indicates whether the user has accessed or used Microsoft Word through a web browser (Word Online) during the reporting period. |
| ExcelWeb | String | Indicates whether the user has accessed or used Microsoft Excel through a web browser (Excel Online) during the reporting period. |
| PowerPointWeb | String | Indicates whether the user has accessed or used Microsoft PowerPoint through a web browser (PowerPoint Online) during the reporting period. |
| OneNoteWeb | String | Indicates whether the user has accessed or used Microsoft OneNote through a web browser (OneNote Online) during the reporting period. |
| TeamsWeb | String | Indicates whether the user has accessed or used Microsoft Teams through a web browser (Teams on the web) during the reporting period. |
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 window for the report. Valid values are: D7, D30, D90, and D180. These correspond to 7, 30, 90, and 180-day periods, respectively.
The allowed values are D7, D30, D90, D180. The default value is D7. |
| Date | Date | Specifies the reporting date to retrieve usage activity for individual users. The format must be YYYY-MM-DD. Only dates within the last 30 days are supported. |