Get EmailAppUsage report

Retrieve the reports of Exchange Email App Usage. The response will be a CSV file in a binary stream.

Note: You can go to Office 365 Reports - Email apps usage to check the meaning of different views.

Prerequisites

The following scopes are required to execute this API:

  • Reports.Read.All

Note: Permission scopes are listed in least privilege required order.

HTTP request

GET /reports/EmailAppUsage(view=view-value, period=period-value, date=date-value)/content

Request headers

Name Description
Authorization Bearer {token}. Required.

Request body

In the request URL, provide following query parameters with values.

Parameter Type Description
view ViewType View is an enumeration type, used to determine which type of information that current report should return. Can not be null.
period PeriodType Period is an enumeration type, used to specify the aggregate type.
date String Specifies the day to a view of the users that performed an activity on that day. Must have a format of YYYY-MM-DD. Only available for the last 30 days and is ignored unless view type is Detail

Note: When view type is Detail, the period parameter will be ignored. For other view types, date parameter will be ignored. If you call with Detail view along with PeriodType, the return data is a list of all users that are licensed for the product with their respective last activity date.

The following ViewType are available in this report:

  • Detail
  • Apps
  • Users
  • Versions

The following PeriodType are available in this report:

  • D7
  • D30
  • D90
  • D180

Response

If successful, this method returns 302 Found response redirecting to a pre-authenticated download URL for the report.

To download the contents of the file your application will need to follow the Location header in the response. Many HTTP client libraries will automatically follow the 302 redirection and start downloading the file immedately.

Pre-authenticated download URLs are only valid for a short period of time (a few minutes) and do not require an Authorization header to download.

Example

Here is an example of how to call this API.

Request

Here is an example of the request to get detail view with period of 7 days.

GET https://graph.microsoft.com/beta/reports/EmailAppUsage(view='Detail',period='D7')/content

Response

Here is an example of the response.

HTTP/1.1 302 Found
Content-Type: text/plain
Location: https://reports.office.com/data/download/JDFKdf2_eJXKS034dbc7e0t__XDe

Follow the 302 redirection and the downloading CSV file will have the schema as belowing.

HTTP/1.1 200 OK
Data as of,User principal name,User display name,Deleted,Deleted date,Last activity date (UTC),Mail (iOS/Mac),Outlook (Mac),Outlook (Windows),Outlook (mobile),Other (mobile),Outlook on the web,POP3,IMAP4,SMTP,Reporting period in days

Other valid requests

GET https://graph.microsoft.com/beta/reports/EmailAppUsage(view='Detail',date='2017-02-02')/content
GET https://graph.microsoft.com/beta/reports/EmailAppUsage(view='Apps',period='D7')/content
GET https://graph.microsoft.com/beta/reports/EmailAppUsage(view='Users',period='D7')/content
GET https://graph.microsoft.com/beta/reports/EmailAppUsage(view='Versions',period='D7')/content