Usage Analytics
Analyze Microsoft 365 license utilization across your organization. Identify unused licenses, optimize allocations, and track license trends to reduce costs and ensure compliance.
Usage Overview
Key metrics at a glance:
- Total Licenses — All licenses across all subscriptions
- Assigned — Licenses assigned with utilization percentage
- Available — Unassigned licenses with potential monthly savings
- Inactive Users — Licensed users with no sign-in for 30+ days
License Utilization by SKU
| License | Total | Assigned | Available | Utilization | Monthly Cost |
|---|---|---|---|---|---|
| Microsoft 365 E5 | 2,500 | 2,456 | 44 | 98% | $142,500 |
| Microsoft 365 E3 | 5,000 | 4,234 | 766 | 85% | $180,000 |
| Microsoft 365 Business Premium | 3,000 | 2,876 | 124 | 96% | $66,000 |
| Exchange Online Plan 1 | 1,500 | 1,234 | 266 | 82% | $6,000 |
Inactive Licensed Users
Users with assigned licenses but no sign-in activity may represent optimization opportunities:
- No activity (30 days) — Users who haven’t signed in for a month
- No activity (60 days) — Users who haven’t signed in for two months
- No activity (90+ days) — Users who haven’t signed in for three or more months
Example Inactive Users
| User | Licenses | Last Sign-In | Monthly Cost | Action |
|---|---|---|---|---|
| john.former@company.com | M365 E5 | 95 days ago | $57.00 | Remove License |
| jane.leave@company.com | M365 E3 | 45 days ago | $36.00 | Review |
| bob.contractor@company.com | M365 Business Premium | 32 days ago | $22.00 | Review |
Service Plan Usage
Track which service plans within licenses are actually being used:
Microsoft 365 E5 Service Plans (2,456 licensed users)
| Service Plan | Active Usage |
|---|---|
| Exchange Online | 95% active |
| Microsoft Teams | 92% active |
| SharePoint Online | 78% active |
| Power BI Pro | 34% active |
| Microsoft Defender for Endpoint | 89% active |
License Trends
Assignment Trend (6 months)
| Month | Assigned Licenses |
|---|---|
| January | 10,234 |
| February | 10,456 |
| March | 10,678 |
| April | 10,890 |
| May | 11,045 |
| June | 11,234 |
Cost Trend (6 months)
| Month | Monthly Cost |
|---|---|
| January | $385,200 |
| February | $387,800 |
| March | $390,400 |
| April | $392,100 |
| May | $393,200 |
| June | $394,500 |
Optimization Recommendations
Remove licenses from inactive users
66 users with E3/E5 licenses haven’t signed in for 90+ days. Potential savings: $2,838/mo
Downgrade underutilized E5 to E3
234 E5 users don’t use E5-specific features (Power BI, Defender, etc.). Potential savings: $4,914/mo
Right-size Exchange Online licenses
156 users with standalone Exchange could use included M365 licenses. Potential savings: $624/mo
API Reference
GET /api/identity/licenses/usage— Get license usage summaryGET /api/identity/licenses/inactive-users— Get inactive licensed usersGET /api/identity/licenses/service-plans— Get service plan utilizationGET /api/identity/licenses/trends— Get license trends over timeGET /api/identity/licenses/recommendations— Get optimization recommendations
Last updated on