Need to export report of one drive storage for users who no longer active and left the company Past 90 days. How do i achieve this report from admin centre.

To export a report of OneDrive storage for users who are no longer active and have left the company in the past 90 days, you can follow these steps in the Microsoft 365 Admin Center:

1. Navigate to Reports: Go to the Reports section in the Microsoft 365 Admin Center.
2. Access Storage Usage: Select Storage and then choose Storage usage by inactive users. This report will show you up to 5,000 of the least active users in your tenant, with a minimum inactivity period of 90 days.
3. Export the Report: You can export the report data to a CSV file by selecting the Export link. This will allow you to analyze the data further.
4. Check Last Activity: To determine if any documents of inactive users are still being used by others, refer to their last activity date from the OneDrive storage report.

By following these steps, you should be able to generate the report you need for inactive users who have left the company.

Hi there,

Thanks for reaching out and sharing what you need. I understand you want to export a report showing OneDrive storage for users who haven’t been active and have left the company in the past 90 days, directly from the admin center. There are a couple of ways to do this.

The easiest method is through the Microsoft 365 Admin Center without using any scripts. Go to the Microsoft 365 admin center, then navigate to Reports, Usage, and select OneDrive. Set the report period to 90 days and export the data as a CSV file. This file will include details like the user’s UPN, last activity date, number of files, storage used, and whether the account is deleted. You can then open the CSV in Excel and filter for users with no activity or those whose last activity was more than 90 days ago. Here is a help article that you can check, this might help: https://v4.hkg1.meaqua.org/en-us/microsoft-365/admin/activity-reports/onedrive-for-business-usage-ww?view=o365-worldwide

If you also need to check for deleted or unlicensed accounts, look at the “Deleted” column. Keep in mind that deleted users can still appear in reports for up to 180 days after removal.

If your organization hides user names in reports, you’ll need to temporarily turn off the setting that conceals identities under Org Settings → Services → Reports, then export again. After that, you can turn the setting back on.

This will give you a ready-to-use CSV showing storage usage and last activity, which you can cross-check with your list of leavers. If the licenses for those users were removed, their OneDrive becomes unlicensed and will eventually be archived or deleted according to your retention policies.

Please let me know if this helps and need clarification, I'm happy to help!

Warm regards,

Edward