Office 365 Reports in the Admin Center - OneDrive for Business usage
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, the OneDrive card on the dashboard gives you a high-level view of the value you are getting from OneDrive for Business in terms of the total number of files and storage used across your organization. You can then drill into it to understand the trends of active OneDrive accounts, how many files are users interacting with as well as the storage used. It also gives you details for each user's OneDrive.
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 do I get to the OneDrive Usage Report?
In the Microsoft 365 admin center, select Reports and then Usage from the left menu or click on the Reports widget.
Use the Select a report drop-drop at the top left and select OneDrive usage.
Interpret the OneDrive usage report
You can get a view into OneDrive for Business usage by looking at the Accounts, Files, and Storage views.
||The OneDrive usage report shows 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 up to 28 days from the current date (not the date 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.
NOTE: At times there may be unpredictable delays in data collection and processing which may delay report generation. The displayed report date is always reflective of the current date for which the system has processed report data. We strive to keep these within 24-48 hours from the time of activity.
||The Accounts view shows the trend in the number of total and active OneDrive accounts. "Active accounts" are any in which users view, modify, upload, download, share, or sync files.
||The Files view shows the number of number of total and active files. A file is considered active if it has been saved, synced, modified or shared within the specific time period.
NOTE: A file activity can occur multiple times for a single file, but will count only as one active file. For example, you can save and sync the same file multiple times over a specified time period, but it will count only as one single active file and one single synced file in the data.
||The Storage view shows the trend in the amount of OneDrive storage you're using.
> NOTE: The size includes any versions and metadata associated with the files.
||On the Accounts chart, the Y axis is the number of OneDrive accounts.
On the Files chart, the Y axis is the number of files stored in OneDrive.
On the Storage chart, the Y axis is the amount of OneDrive storage used.
The X axis on all charts is the selected date range for this specific report.
||You can filter the series you see on the chart by clicking on an item in the legend. For example, on the Files chart, tap or click Total files or Active files. On the Accounts chart, tap or click Total accounts or Active accounts. Or on the Storage chart, tap or click Storage used. Changing your selection doesn't change the information in the table.
||The table shows you a breakdown of data for each user's OneDrive. To appear in the table, a user needs to have been assigned a product license that includes OneDrive, and they need to have SharePoint Online turned on. The user also needed to either sign in to the OneDrive sync client, or browse to their OneDrive using a web browser.
If the OneDrive has had file activity, it will have the latest date that the file activity was performed. The rows in the table are sorted by Last activity date so the OneDrive with the most recent file activity appears at the top of the list.
You can add or remove columns from the table.
URL is the web address for the user's OneDrive.
Deleted is the deletion status of the OneDrive. It takes at least 7 days for accounts to be marked as deleted.
Owner is the username of the primary administrator of the OneDrive.
Owner principal name is the email address of the owner of the OneDrive.
Last activity date (UTC) is the latest date a file activity was performed in the OneDrive. If the OneDrive has had no file activity, the value will be blank.
Files is the number of files in the OneDrive.
Active files is the number of active files within the time period. A file is considered active if it has been saved, synced, modified or shared within the selected time period.
NOTE: A file activity can occur multiple times for a single file, but will count only as one active file. For example, you can save and sync the same file multiple times over a specified time period, but it will count only as one single active file and one single synced file in the data. > If files were removed during the specified time period for the report, the number of active files shown in the report may be larger than the current number of files in the OneDrive. > Deleted users will continue to appear in reports for 180 days.
Storage used (MB) is the amount of storage the OneDrive uses in MB. This includes any versions and metadata associated with the files.
If your organization's policies prevent 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 Microsoft 365 admin center Preview.
||Click or tap the Manage columns icon to add or remove columns from the report.
||You can also export the report data into an Excel .csv file, by clicking or tapping the Export link. This exports the date for each OneDrive and allows you to do simple sorting and filtering for further analysis. If you have less than 2000 OneDrive accounts, you can sort and filter within the table in the report itself. If you have more than 2000 OneDrive accounts, you need to export the data to filter and sort.
NOTE: When the data is exported to an Excel file, note that the date the content report was generated is reflected in the file in the Data as of column.