Office 365 Reports in the Admin Center - Active Users

The new Office 365 Reports dashboard shows you the activity overview across the Office 365 products in your organization. It enables you to drill in to individual product level reports to give you more granular insight about the activities within each product. Check out the Reports overview topic.

For example, you can use the Active Users report to find out how many product licenses are being used by individuals in your organization, and drill down for information about which users are using what products. This report can help administrators identify underutilized products or users that might need additional training or information.

Note: You must be a global administrator in Office 365 or an Exchange, SharePoint, Skype for Business administrator, or reports reader to see Office 365 reports.

How to get to the Active Users report

  1. Go to the Office 365 admin center > Reports > and click Usage.

    In the admin center, click reports, then usage.
  2. On the Usage page, select Active Users from the drop down.

    In the "Select a report dropdown", click "Active users"

Interpret the Active Users report

Overview of the active users report


The Active Users report can be viewed for trends over the last 7 days, 30 days, 90 days, or 180 days. However, if you click into a particular day in the report, the table (7) will show data for 30 days, up to the date (2) for when the report was generated.


Each report has a date for when this report was generated. The reports usually reflect a 24 to 48 hour latency from time of activity.


The Active Users chart shows you daily active users in the reporting period separated by product.

The Services chart shows you count of users by activity type and Service.


  • On the Active Users chart, the x axis shows the selected reporting time period and the y axis displays the daily active users separated and color coded by licence type.

  • On the Services activity chart, the X axis displays the individual services your users are enabled for in the given time period and the Y axis is the Count of users by activity status, color coded by activity status.


You can filter the series you see on the chart by clicking on an item in the legend. Changing this selection doesn’t change the info in the grid table.


You can also export the report data into an Excel .csv file, by clicking or tapping the Export Office 365 reports - export your data to an Excel file link. This exports data of all users and enables you to do simple sorting and filtering for further analysis. If you have less than 2000 users, you can sort and filter within the table in the report itself. If you have more than 2000 users, in order to filter and sort, you will need to export the data.


You can change what information is displayed in the grid table with column controls.

If your subscription is operated by 21Vianet, then you will not see Yammer.

User level filter options

Column Name




Display Name

User's configured Display Name. Distinct from "First name, Last name", and username (

Licensed For

This column will show a True or False value depending on whether the user has been enabled to use the service.

Last Activity Date

Shows the latest date the user was active in the specific product. You can refer to the individual product user activity report to get clarity on details of activity within each product. See Active user in Office 365 usage reports for more information.

License Assign Date

Date the user was assigned the specific product license.


 This column will show a True or False value depending on whether the user was deleted in the selected reporting period.

Deleted Date

Date the user was deleted

Products assigned

Products the user has been licenced for and enabled to access.

If your organization's policies prevents you from viewing reports where user information is identifiable, you can change the privacy setting for all these reports. Check out the How do I hide user level details? section in the Activity Reports in the Office 365 Admin Center.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.