Microsoft 365: Drive Summary (M365, Sharepoint, OneDrive)

Category: Storage Insights Metrics

Description:
This metric generates a comprehensive summary of Microsoft 365 drive storage details. It includes key information such as site name, drive name, creator, creation date, and the remaining storage percentage for each drive.

Purpose:
To provide IT organizations with a clear and concise overview of storage utilization across Microsoft 365 environments, enabling better management, planning, and resolution of storage-related issues.

Use Cases:

1. Resource Monitoring: Keep track of storage utilization across all drives to ensure sufficient capacity is available.

2. Capacity Planning: Use remaining storage data to plan for upgrades or archival actions, ensuring continued system performance.

3. Accountability: Identify the owner (Created By) of drives to facilitate follow-ups for cleaning or optimizing storage.

4. Auditing: Document drive creation dates and usage trends to support audits and compliance efforts.

5. Optimization Opportunities: Highlight drives with very high or very low usage for potential cleanup or reallocation.

How it Works:
The metric utilizes Liongard’s Microsoft 365 Inspector to extract and summarize storage-related data for each drive. The JMESPath query outputs the following details for every drive:

• Site Name

• Drive Name

• Created By (Owner)

• Created On (Date of Creation)

• Remaining Storage in Percentage

Beneficiaries:

• IT Teams: Gain insights into storage usage across all sites and drives.

• Organizations: Plan for future storage needs and maintain efficient operations.

• Decision-Makers: Access actionable summaries to guide resource allocation and policy adjustments.

Notes for Customization:

1. Additional Enhancements:

   • Add Usage Details: Include fields like Used Storage or Total Capacity to provide a fuller picture of the drive’s storage status.

   • Highlight Critical Drives: Apply conditional formatting or flags for drives with less than a specified threshold of remaining storage (e.g., 10%).

   • Aggregate Data: Create summary statistics, such as total remaining storage or average usage across all drives.

2. Why Modify:

   • Tailored Reporting: Customize the fields and output to align with organizational needs, such as compliance with specific storage policies.

   • Enhanced Usability: Expand data points to allow quicker decision-making, such as identifying which drives to prioritize for cleanup or migration.

   • Automation Opportunities: Tie the metric to workflows that notify teams of critical storage issues or trigger cleanup operations.