Microsoft 365: List of Drives Over 80% Capacity (Includes Sharepoint and OneDrive)

Category: Storage Monitoring Metrics

Description:
This metric provides a detailed overview of Microsoft 365 drives - including Sharepoint and Onedrive drives that have exceeded 80% of their storage capacity. It highlights drives with limited available quota and includes essential details such as site name, drive name, owner, creation date, total capacity, and percentage of capacity used.

Purpose:
To enable IT organizations to monitor storage usage effectively, address potential capacity issues, and plan for future storage needs. The metric helps prevent disruptions due to full drives and ensures efficient utilization of available resources.

Use Cases:

1. Proactive Monitoring: Detect drives nearing capacity to prevent service interruptions or data issues.

2. Resource Planning: Assist in planning for additional storage or archiving older data to optimize available capacity.

3. Cost Management: Avoid unexpected costs by identifying storage over-utilization early and reallocating or upgrading as needed.

4. Operational Efficiency: Streamline processes to identify and act on capacity issues across multiple environments or tenants.

5. Policy Compliance: Ensure drives remain within organizational storage policies and guidelines.

6. User Support: Provide detailed insights to administrators or end-users on storage usage to guide actions like cleanup or data migration.

How it Works:
This metric leverages Liongard’s Microsoft 365 Inspector to analyze storage data. Using a JMESPath query, it filters drives where the remaining quota (quota.percentOfQuotaRemaining_r) is less than 20%, effectively identifying drives that have utilized over 80% of their capacity. The output provides:

• Site Name

• Drive Name

• Owner Information (Created By)

• Creation Date

• Total Capacity (in MB)

• Percentage of Capacity Used

Beneficiaries:

• IT Teams: Gain visibility into potential storage issues to maintain operational efficiency.

• Organizations: Avoid disruptions or inefficiencies caused by storage limitations.

• Administrators: Support informed decision-making for storage management and capacity planning.

Notes for Customization:

1. Additional Enhancements:

   • Threshold Adjustments: Modify the threshold (currently at 20% remaining) to align with organizational policies, such as flagging drives at 30% remaining.

   • Automated Notifications: Integrate this metric with Liongard alerting to notify teams of drives nearing capacity automatically.

2. Why Modify:

   • Adapt to Specific Needs: Tailor the query to include more detailed storage metrics or align thresholds with different compliance or operational requirements.

   • Improve Scalability: Expand to cover other storage-related metrics, such as tracking storage growth trends over time.

   • Enhance Reporting: Use this metric as a foundation for creating storage utilization reports for internal reviews or client presentations.