Captures insights into how users access their email accounts, including which email clients (desktop, mobile, web) they use and what activities they perform on those platforms.

Select

The driver 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 driver.

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 EmailAppUsageUserDetail WHERE Period = 'D7' 
SELECT * FROM EmailAppUsageUserDetail WHERE Date = '2023-04-19'
SELECT * FROM EmailAppUsageUserDetail 

Columns

Name	Type	Description
ReportRefreshDate	Date	The date on which the email app usage report data was last refreshed. This reflects the most recent snapshot available from the reporting source.
UserPrincipalName	String	The unique user principal name (UPN) of the individual whose email app usage is being reported. Typically in the format user@domain.
DisplayName	String	The full display name of the user as registered in the Exchange environment. This helps identify the individual associated with the usage data.
IsDeleted	Boolean	Indicates whether the user account has been deleted from the directory. A value of true means the account has been removed, while false means it is still active.
DeletedDate	Date	The date on which the user account was deleted, if applicable. This is relevant only if the 'IsDeleted' field is true.
LastActivityDate	Date	The most recent date on which the user accessed or interacted with any email application. Useful for identifying active vs inactive users.
MailForMac	String	Indicates whether the user accessed their mailbox using the Mail app on macOS. Captures client-specific activity.
OutlookForMac	String	Indicates usage of Microsoft Outlook for Mac by the user. Helps track platform-specific adoption of Outlook clients.
OutlookForWindows	String	Indicates whether the user accessed their email through Microsoft Outlook installed on a Windows device.
OtherForMobile	String	Captures email access through mobile applications other than Microsoft Outlook, such as third-party apps, on a smartphone or tablet.
OutlookForMobile	String	Indicates usage of the Microsoft Outlook mobile app on devices such as iPhones, Android phones, or tablets.
OutlookForWeb	String	Indicates whether the user accessed their mailbox using Outlook on the web (Outlook Web App or OWA) through a browser.
POP3App	String	Represents the use of email clients that connect to Exchange servers using the POP3 protocol. Lists all applicable applications separated by commas.
IMAP4App	String	Represents the use of email clients that connect using the IMAP4 protocol. Lists the names of such applications used by the user.
SMTPApp	String	Lists applications or services that sent messages on behalf of the user using the SMTP protocol. Includes clients like printers or third-party tools.
ReportPeriod	Integer	Specifies the number of days covered by the report, used to summarize app usage over time. Common values are 7, 30, 90, or 180.

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	Defines the reporting duration using a symbolic value such as D7, D30, D90, or D180, which correspond to the number of days included in the report. The allowed values are D7, D30, D90, D180. The default value is D7.
Date	Date	The specific date for which the report details are requested, in the format YYYY-MM-DD. This must fall within the last 30 days, as only recent activity is available.