🎉 Our Office 365 Reporting Tool is now available in Azure Marketplace 🚀
This website uses cookies to improve your experience. We'll assume you're ok with this. Know more.
Azure AD

How to Find Office 365 Groups Storage Report

Is your Office 365 group storage spiraling out of control? This is a challenge that many professionals face, and it can severely impact your workflow and productivity. But don't worry – we won't leave you hanging. Follow the strategies below to generate an Office 365 group usage report that will help you streamline Microsoft 365 group storage management.

Using Microsoft 365 Admin Center

Microsoft 365 Permission Required
Global Admin or a User Summary Reports Reader.
  • Login to the Microsoft 365 admin center.
  • Select the Groups activity section under Reports»Usage»Microsoft 365 Apps.
  • Here, you can find both the SharePoint site and mailbox storage of respective groups on a daily basis under the Storage section.
Using Microsoft 365 Admin Center

Using Windows PowerShell

Microsoft 365 Permission Required
Global Admin or a User Summary Reports Reader.
  • Connect to SharePoint Online PowerShell.
  • You can get the storage details of Microsoft 365 groups using the below cmdlets. However, it requires a few lines of code.
    Get-UnifiedGroup
    Get-SPOSite 

Using PowerShell Script

Microsoft 365 Permission Required
Global Admin or a User Summary Reports Reader.
  • As there is no easy way to get the storage occupied by all the Microsoft 365 groups, we have prepared a PowerShell script that will include a combination of various cmdlets to get the Office 365 groups usage report.
  • Download and run the following script in the Administrator PowerShell.
Using PowerShell Script
GetOffice365GroupsStorage.ps1

Say goodbye to Microsoft 365 groups storage issues!

With AdminDroid Microsoft 365 groups usage reporting tool, admins gain visibility into the entire details related to M365 groups and their storage capabilities, thereby enhancing your organization's productivity.

Microsoft 365 Group Mailbox Management

Utilize Microsoft 365 mailbox usage reports to investigate the daily statistics of group mailboxes, ensuring you are continuously informed about the various attributes of these mailboxes.

SharePoint Site Usage Analytics

Manage SharePoint site storage effectively by routinely monitoring the usage of SharePoint Online sites. This involves tracking active sites, active files, page views, and the daily storage consumption by users.

Real-time Alerts on Storage Quota Modifications

Generate an alert to identify any abnormal count of site quota modifications occurring within a short timeframe.

Delete Inactive SharePoint Document Libraries

Remove inactive SharePoint libraries that have not been used for an extended period to optimize Office 365 group storage.

Interactive Dashboards on Office 365 Groups Usage

Leverage the in-built usage dashboards to visualize the Microsoft 365 groups usage reports in a customized way.

Get Instant updates to Manage Microsoft 365 Groups

Eliminate the need for manual syncing and ensure that you always have the most up-to-date information on Microsoft 365 groups' storage by automatic syncing.

Overall, AdminDroid allows you to efficiently manage Office 365 groups with a plethora of reports and features available! By monitoring the SharePoint storage usage reports, you can seamlessly share content to the Microsoft 365 users and perform group storage related activities that ensure uninterrupted collaboration.

Explore a full range of reporting options

Important Tips

Review the daily usage of M365 groups and delete unwanted files when the storage consumption is high.

To control storage consumption within Office 365 groups, it's necessary to examine file restoration activities in SharePoint Online and verify the necessity of the restored files.

Ensure regular cleaning of the SharePoint Online recycle bins to maximize storage space and enhance Microsoft 365 groups’ performance.

Common Errors and Resolution Steps

The following are possible errors and troubleshooting hints while dealing with the Office 365 groups storage report.

Error The term 'Get-UnifiedGroup' is not recognized as the name of a cmdlet, function, script file, or operable program.

This happens because the Exchange Online module may not be installed properly.

Fix Install the Exchange Online PowerShell module. If it is already installed, updating it could resolve the issue.
// Run the below cmdlet for installing it.
Install-Module -Name ExchangeOnlineManagement
// Run the below cmdlet for updating it.
Update-Module -Name ExchangeOnlineManagement

Error The ‘Connect-PnPOnline’ command was found in the module ‘PnP.PowerShell’, but the module could not be loaded. For more information, run ‘Import-module PnP.PowerShell.

The error may happen when a version conflicts with the PnP PowerShell module installed in the machine.

Fix Uninstall all the versions of PnP PowerShell from your machine and install the required version.
// Run the below cmdlet to uninstall all the versions of PnP PowerShell.
Uninstall-Module -Name PnP.PowerShell -AllVersions -Force
// Run the below cmdlet to install the 1.12 version of PnP PowerShell.
Install-Module PnP.PowerShell -RequiredVersion 1.12 -Force

Error Something went wrong so we couldn’t upload <Filename>

This happens when you upload a file to a M365 group whose storage is full.

Fix Delete unwanted files from the group or increase the size of the group’s site using the below PowerShell cmdlet.
Set-SPOSite -Identity <Site URL> -StorageQuota <value> –StorageQuotaWarningLevel <value>

Error No valid OAuth 2.0 authentication session exists.

This happens when you connect to SharePoint Online using PowerShell 7.

Fix Connect to SharePoint Online using Windows PowerShell.
Connect-SPOService

Error Current site is not a tenant administration site.

This happens while connecting to SharePoint Online using the cmdlet Connect-SPOService without using the word ‘admin’ in it.

Fix Include the word ‘admin’ in the URL.
https://<YourTenantName>-admin.sharepoint.com/

Frequently Asked Questions

Monitor the Office 365 Group Usage Report to Avoid Storing Data in Unsecured Locations in Microsoft 365

What happens if the Office 365 groups’ storage becomes full?

What happens if the Office 365 groups’ storage becomes full? +

Office 365 groups' storage allocation empowers users to securely store and share files, fostering seamless collaboration and information exchange. You may face the following issues if the Microsoft 365 groups’ storage is not managed properly.

  • Users will encounter a restriction where they are unable to upload files into the Microsoft 365 groups.
  • Reaching Microsoft 365 group storage limit will make files read-only in SharePoint Online, restricting any further modifications or edits.
  • Users may use personal or unsecured storage locations, which results in potential data breaches and unauthorized access.
  • If it is a mail-enabled group, reaching the Office 365 group storage limit may prevent new emails from being received. Senders will likely receive a notification stating that the “recipient's mailbox is full”.

With AdminDroid, you can check and modify Microsoft 365 group mailbox size, ensuring it aligns with your group’s requirements.

  • Make use of the easy filters functionality to view various storage quotas configured for group mailboxes.
  • Here you can get the entire details of the mailbox size such as prohibit send quota, prohibit send receive quota, archive quota, archive warning quota, issue warning quota, etc.
exchange-mailbox-size

When will an Microsoft 365 group face storage issues?

When will an Microsoft 365 group face storage issues? +

Microsoft 365 groups may face storage issues under the following conditions,

  • Modifying documents frequently may increase the SharePoint Online version history, which can consume significant storage space over time.
  • If you set up data retention policies for a longer duration, the Office 365 group storage may pile up faster.
  • Not configuring Exchange Online attachment size limit can contribute to a significant increase in Microsoft 365 group mailbox storage.
  • Uploading larger files without compressing can quickly consume the available storage space.
  • If you have auto-archive settings enabled, emails and other content may be moved to an archive mailbox, increasing the overall storage of Office 365 groups.

What is the storage allocated for Office 365 groups?

What is the storage allocated for Office 365 groups? +

Office 365 groups' files utilize the storage allocated to their corresponding SharePoint Online site collections. The overall SharePoint storage capacity depends on the number of licensed users within your organization.

  • By default, each Microsoft 365 organization is provided with 1 TB of storage space. Additionally, there is an additional 10 GB of storage allocated per licensed user.
  • You can add more SharePoint storage to your subscription by purchasing the Office 365 extra file storage add-on.
  • The maximum storage capacity you can configure for a site collection is 25 TB.

How to check the available storage space in SharePoint Online?

  • Login to the SharePoint Online admin center.
  • In the upper right corner of the page, you will find the total SharePoint storage space available in your Microsoft 365 environment.
storage-space

How to set storage quotas for Microsoft 365 groups?

How to set storage quotas for Microsoft 365 groups? +

To prevent the issues faced by storage-exceeded groups in Office 365, you can set up storage quotas for SharePoint sites based on their requirements. To enable manual storage limits,

  • Login to the SharePoint online admin center.
  • Under the Settings tab, select site storage limits and click the Manual option.

Now, you can set up storage quotas for SharePoint sites in the below ways,

  • Using Microsoft 365 Admin Center Navigate to Active teams & groups under Teams & groups. Select the group and click on Edit in Storage Limit option. Enter the desired value in the Maximum storage for this site box and click Save.
  • Using Windows PowerShell Run the below cmdlet to set storage quota in SharePoint Online.
Set-SPOSite -Identity <Site URL> -StorageQuota <value> –StorageQuotaWarningLevel <value>

Here, you can also specify the storage warning quota for the SharePoint sites. You must enter the value in MB.


For Microsoft 365 group mailbox management, run the following PowerShell cmdlet to configure storage quotas for a group mailbox in Exchange Online.

Set-Mailbox -GroupMailbox <Group Display Name> -IssueWarningQuota <value> -ProhibitSendQuota <value> -ProhibitSendReceiveQuota <value> -UseDatabaseQuotaDefaults $false 

With AdminDroid, you can create an alert when a SharePoint site storage limit is modified.

  • Follow the steps to create an "Alert" by applying easy filters for the "Site URL" attribute.
  • Pro Tip: By reviewing the Modified Quota Info property, you can determine if the storage quota has been adjusted appropriately based on the requirement of the Microsoft 365 group site.
sposite-storage-limit

How to monitor the storage occupied by Office 365 groups?

How to monitor the storage occupied by Office 365 groups? +

To maintain an efficient and productive collaborative working environment, it is imperative for IT administrators to regularly monitor storage used by Office 365 groups. By proactively monitoring and removing unwanted files regularly, admins can optimize storage capacity and enhance Microsoft 365 group mailbox size management. You can get the Office 365 groups storage activity report in below ways:

  • Microsoft 365 Admin Center To find the storage used by Microsoft 365 groups, navigate to the Groups activity report under Reports»Usage»Office 365.
  • Microsoft PowerShell Run the PowerShell script provided to get non-owner mailbox access report in Exchange Online.

As a drawback, you cannot get the exact storage occupied by Office 365 groups through Microsoft 365 admin center. Also, it is impossible to get the complete group storage usage report using a single cmdlet in PowerShell.

With AdminDroid, you can monitor the storage occupied by Microsoft 365 groups and find the groups that are occupying a high amount of storage.

  • Using the sorting functionality, you can arrange the group storage in decreasing order.
  • Pro Tip: Not stopping there, you can also schedule the storage information of sorted groups to be sent to your mailbox by saving it as a "View".
storage-used

How to manage Microsoft 365 groups storage productively?

How to manage Microsoft 365 groups storage productively? +

Follow the steps below to efficiently manage Office 365 groups storage to prevent SharePoint online storage quota exceeded error.

  • Set up Office 365 data retention policies for a short period for groups that have less important information.
  • Configure SharePoint Online storage limit manually by assigning higher limits to groups requiring extensive collaboration and lower limits to groups with minimal collaboration needs.
  • Define storage warning quotas for Microsoft 365 groups’ sites and mailboxes to receive notifications when the designated storage threshold is reached.
  • Inform the groups’ owners about the Office 365 group storage allocation and ask them to manually delete unwanted files.

Get notified when the Office 365 groups’ storage warning quota is reached!

With AdminDroid, you can easily find the sites that crossed the SharePoint Online quota warning and clean up the storage before it reaches maximum capacity.

Here, you can find details such as the current storage, the percentage of storage used, storage warning level, the percentage of warning storage, storage maximum level, and more.

+

Kickstart Your Journey With
AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities

Download Now
User Help Manuals Compliance Docs
x
Delivering Reports on Time
Want a desired Microsoft 365 reports every Monday morning? Ensure automated report distribution and timely delivery with AdminDroid's Scheduling to your email anytime you need.
Delivering Reports on Time
Schedule tailored reports to execute automatically at the time you set and deliver straight to the emails you choose. In addition, you can customize report columns and add inteligent filtering to the activities just from the previous day to suit your Microsoft 365 report requirements.
Set It, Schedule It, See Results- Your Reports, Your Way, On Your Time!
Time Saving
Automation
Customization
Intelligent Filtering
Give Just the Right Access to the Right People
Grant fine-tuned access to any Microsoft 365 user with AdminDroid’s Granular Delegation and meet your organization’s security and compliance requirements.
Give Just the Right Access to the Right People
Create custom roles loaded with just the right permissions and give access to admins or normal users within AdminDroid. The result? A streamlined Microsoft 365 management experience that aligns your organization's security protocols and saves your invaluable time and effort.
Align, Define, Simplify: AdminDroid's Granular Delegation
Smart Organizational Control
Effortless M365 Management
Simplified Access
Advanced Alerts at a Glance
Receive quick notifications for malicious Microsoft 365 activities. Engage with the AdminDroid’s real-time alert policies crafted to streamline your security investigations.
Advanced Alerts at a Glance
Stay informed of critical activities like suspicious emails and high-risk logins, bulk file sharing, etc. Through creating and validating ideal alert policies, AdminDroid provides a comprehensive approach to real-time monitoring and management of potential threats within your organization.
AdminDroid Keeps You Always Vigilant, Never Vulnerable!
Proactive Protection
Real-time Monitoring
Security Intelligence
Threat Detection
Merge the Required Data to One Place
Combine multiple required columns into one comprehensive report and prioritize the information that matters most to you with AdminDroid’s Advanced Column Customization.
Merge the Required Data to One Place
This column merging capability offers a flexible way to add different columns from various reports and collate all the essential data in one place. Want to revisit the customized report? Save it as a 'View’, and your unique report is ready whenever you need it.
Merge with Ease and Save as Views!
Custom Reporting
Unique View
Desired Columns
Easy Data Interpretation
Insightful Charts and Exclusive Dashboards
Get a quick and easy overview of your tenant's activity, identify potential problems, and take action to protect your data with AdminDroid’s Charts and Dashboards.
Insightful Charts and Exclusive Dashboards
With AdminDroid charts and dashboards, visualize your Microsoft 365 tenant in ways you've never thought possible. It's not just about viewing; it's about understanding, controlling, and transforming your Microsoft 365 environment.
Explore Your Microsoft 365 Tenant in a Whole New Way!
Executive overviews
Interactive insights
Decision-making
Data Visualization
Efficient Report Exporting for Microsoft 365
Downloading your reports in the right file format shouldn’t be a hassle with AdminDroid’s Report Export. Experience seamless report exporting in various formats that cater to your needs.
Efficient Report Exporting for Microsoft 365
Navigate through diverse options and export Microsoft 365 reports flawlessly in your desired file format. Tailor your reports precisely as you need them and save them directly to your computer.
Take Control, Customize and Deliver- Your Office 365 Data, Exported in Your Way!
Easy Export
Seamless Downloading
Data Control
Manage Microsoft 365

Get AdminDroid Office 365 Reporter Now!