Office 365

New usage reports for SharePoint Online, OneDrive for Business and Exchange Online

Share on Facebook Share on Twitter Share on Linkedin Share via OneNote Share via Email Print

Since the first rollout of the usage activity dashboard in March, we’ve continued our work to provide you with a better reporting experience. Many of the old usage reports have now been migrated to the new admin center. Today, we are happy to announce three new usage reports for SharePoint Online, OneDrive for Business and Exchange Online, which provide you with additional insights about how end users in your organization are using and adopting Office 365.

Here’s a look at these new reports for SharePoint Online, OneDrive for Business and Exchange Online:

SharePoint Online activity report

The new SharePoint activity report provides you with details about how users in your organization use SharePoint Online team sites to store and collaborate on files. You can use the report to see which users are active on SharePoint and engage with files stored within team sites—a file is counted as active if it has been created, modified, deleted, shared internally or externally or synced to clients. You can also see which users sync documents back to their local machine and if they share documents internally or externally. In the future, we’ll update the report to reflect additional actions that users can perform in SharePoint, such as page visits. This is a user-centric report complimenting the SharePoint Online team site usage report that you can use to access details per team site.

New usage reports for SharePoint OneDrive and Exchange 1

The usage activity dashboard has been updated with a new card that provides you with a high-level summary of the user file activity within all your SharePoint Online team sites. You can use the card to get a quick understanding of the total number of files across your SharePoint site and how many of these files were edited, viewed, synced (using any client), shared internally or externally. The bar graph shows how many of your users are engaged in file activity in comparison to the number of users you have assigned a SharePoint Online license to. This is a key indicator for adoption and allows you to identify the need for additional end user training and communication.

New usage reports for SharePoint OneDrive and Exchange 2

OneDrive for Business activity report

The new OneDrive for Business activity report enables you to understand which users are using OneDrive in your organization within Office 365. Together, with the already available OneDrive for Business usage report, you now have a holistic view of how your users are leveraging OneDrive to store and collaborate on documents. The report shows how many files a user is actively engaging with across OneDrive accounts in your organization and which users sync files back to their local machine. The report is helpful to identify users that might need additional training and communication around how OneDrive can help them to store files and collaborate with others, or users that need support.

Mailbox usage report

The new Mailbox usage report—together with the already available email activity report—provides you with a complete picture about how your users are using their mailboxes. You can easily see how many mailboxes are actively being used in your organization, how many items are stored in each user’s mailbox and how much storage space these items take up. The report also allows you to identify which users have a mailbox that is close to reaching the maximum storage limit and might need help to delete or archive items.

New usage reports for SharePoint OneDrive and Exchange 3

A completely new reporting experience

These three new reports are an important step in our mission: Make it easy for you to understand how your users are using—or not using—Office 365, so you can quickly identify issues and areas your users need more training in.

Before creating the new usage activity dashboard, we spent much time talking to customers to fully understand your reporting needs. It became apparent very quickly that you wanted more granular and more actionable reports that provide you with user-level details across all main Office 365 services. Based on your feedback, we revamped the whole Office 365 usage reporting experience and launched the new usage activity dashboard that provides you with an improved reporting experience.

In the new dashboard, we’re consolidating reports to reduce redundancy and make it easier for you to find the information you’re looking for. As a result, you won’t find a one-to-one relationship with the old reports, but improved or brand new reports such as the Office activations, the Yammer activity and the SharePoint activity reports. To make the transition easier, we’ve created a help article that provides you with detailed information on where you can find the information from the old reports in the new admin center.

More to come

In the coming months, we’ll add more reports focusing on Office 365 Groups, Yammer groups, clients used per product, i.e., email or Skype, and Office 365 licenses.

We know you’re all waiting for the Power BI content pack, which will allow you to gain richer insights by enabling you to pivot your organization’s Office 365 usage data with user-level data, like region or department. We’re currently working on the last details, and it will start rolling out later this fall.

Our fall plans also include providing new public APIs that will enable you to programmatically access the usage data and integrate it into custom applications, like a company reporting portal.

Let us know what you think!

Please try the new reports and provide feedback using the feedback button on the site. Or join us in the Admin Center group on the Office 365 Network to let us know any questions. Your input is extremely valuable to us as it helps us to prioritize our work, improve the existing reports and identify additional reporting needs. You can access further details about the reporting dashboard and the new reports on Office Support.

—Anne Michels @Anne_Michels, senior product marketing manager for the Office 365 Marketing team

  1. Sweet! Now how do I get this information into a PowerBI dashboard to share out with my business users / managers?

    • Hi Micah,
      great to hear you like the reports! We’ll share more information on this at Ignite and soon after here on the blog.

  2. Yes, I also would love to see the data in the data feed from the tenant for PowerBI. And also the reports are very nice.

    • Hi Jesse,
      great to hear you also like the reports! We’ll share more information on how to get access to the content pack at Ignite and soon afterwards here on the blog.

  3. Any progress on creating an admin role for access to these reports so we can delegate that to business analysts and stop bugging the system administrators?

    • Hi Geoff, we’re still working on the reporting role. The PowerBI content pack – we’ll share more information at Ignite – will allow you to easily share the information with business groups.

  4. Hi, great to hear the news. Please consider the following enhancement idea:
    1. Add reporting capabilities to track usage of Power BI as well as other workload such as Delve / Delve Analytics
    2. Add sharepoint usage by sites / site collections
    3. Slicer by users’ department / division

    • Thanks for your feedback, Kanjanee. I’ve shared it with the engineering team and we’re looking into it for future enhancements. On no 3, the content pack for PowerBI – we’ll share more information at Ignite – will allow you to pivot by department.

  5. Very nice reports! Question — Is there any way to see if a One Drive for Business User has shared files outside the company? Or shared files with others at all? I do not see this on the report. Would be a nice feature to add, for security reasons. Thanks!

    • Hi Kim, you can find that information in the OneDrive activity report. In the table at the bottom, you can see for each individual user if they have shared filed internally or externally and how many.

  6. Are these reports going to be showing analytics when users work on Sync clients.

    Also, there are some tabular reports but it’s not making things clear and not even sure if they show 7/30/90/180 days report.

    • Hi Jignesh,
      we’re currently working on a report that will show Skype clients. We expect it to become available in the next 1-2 months. The data in the tables at the bottom of the reports changes when you pivot to a different time frame at the top.

  7. Please list the Ignite workshops we should look for to get the information on getting reports out to managers and using with Power BI.

    • Hi Hermine, the Ignite session is called “Understand how your users are using Office 365: What’s new in Office 365 usage reporting?” (BRK2008) and is on Tuesday.

      • Hi Anne,
        I could not find this session on Ignite Session list. I have searched with complete text and with ID too. No luck.
        What is the best way to find it?
        I guess the session name is changed.

        • Hm, that’s weird. Let me give you the info here then: it’s on Tuesday at 4pm in B312-314.Hope to see you there!

          • Found it !!!!!
            The Title is “Understand your users: what’s new in Office 365 Usage Reporting”.
            Lots of Overlapping sessions 🙁
            Let’s see. Thanks Anne.

  8. Awesome stuff!
    When will we see these reports in the O365 powershell or reporting web service?


    • Hi Tom,
      to enable you to programmatically access the data, we’re currently working on APIs. These should be available in a few weeks and we’ll share more information here on the blog soon.

  9. Will you expand SharePoint usage reports to include all SharePoint sites and/or site collections? We currently have no visibility into our user community adoption with SharePoint online and our company site collections. We have rolled out SharePoint access and specific new sites and site collections to a group of users, but have no way to gauge their adoption.

    • Hi Randy, thanks for your feedback. I’ve shared it with our engineering team. We understand that this would be valuable insights for you and we’re looking into this.

  10. Hi Anne, New usage reports looks great. have a query here. Earlier the storage used for OneDrive was represented in TB and now it shows up in bytes. Is there any option where we can see the representation in TB itself?


    • Hi Shinu, currently, there is no option to change this field. I’ve shared your feedback with the engineering team though and they will look into it.

Comments are closed.