Health Matrix

A visual dashboard showing the health status of all tenants across multiple dimensions. Quickly identify problem areas and prioritize remediation efforts.

Matrix View

The Health Matrix displays tenants as rows and health categories as columns. Each cell is color-coded based on the health score for that dimension:

• Healthy (80-100%) — Green
• Warning (50-79%) — Yellow
• Critical (0-49%) — Red
• No Data — Gray

Health Categories

Security Score

Microsoft Secure Score percentage. Measures implementation of security best practices including MFA, conditional access, and endpoint protection.

Source: GET /security/secureScores

MFA Coverage

Percentage of users with MFA enabled. Calculated as users with at least one authentication method registered divided by total enabled users.

Source: GET /reports/authenticationMethods/userRegistrationDetails

License Utilization

Ratio of assigned licenses to purchased licenses. Yellow warning at 50-70%, red at below 50% (wasted spend) or above 95% (capacity risk).

Source: GET /subscribedSkus

Device Compliance

Percentage of Intune-managed devices meeting compliance policies. Only applicable if Intune is configured. Excludes devices pending policy evaluation.

Source: GET /deviceManagement/managedDevices

Email Security

Composite score based on SPF, DKIM, DMARC configuration and anti-phishing policy deployment. Checks primary and all verified domains.

Source: Exchange Online PowerShell / Security & Compliance API

Backup Status

If Backup add-on is enabled, shows backup job success rate over the last 7 days. Red if any backup job has failed twice consecutively.

Source: OpsPilot365 Backup API

Sync Health

Time since last successful data synchronization. Yellow if over 24 hours, red if over 72 hours or if last sync failed.

Interactions

• Click Cell — Opens detailed breakdown for that tenant/category combination
• Click Tenant Row Header — Opens full health report for that tenant
• Click Category Column Header — Sorts tenants by that health dimension
• Hover on Cell — Shows tooltip with exact score and last update time

Filtering

• Show Critical Only — Display only tenants with at least one red cell
• Customer Filter — Show tenants for specific customer
• Tag Filter — Filter by tenant tags
• Hide Healthy — Exclude fully green tenants to focus on problems

Export Options

• Export as CSV — Raw data for all tenants and categories
• Export as PDF — Formatted report with color coding preserved
• Schedule Report — Set up weekly/monthly email delivery

API Reference

• GET /api/msp-portal/health-matrix — Returns health scores for all tenants across all categories
• GET /api/msp-portal/health-matrix/:tenantId — Detailed health breakdown for a specific tenant
• POST /api/msp-portal/health-matrix/refresh — Force recalculation of health scores (rate limited)

Refresh Schedule

Health scores are recalculated automatically on the following schedule:

• Security Score: Every 6 hours
• MFA Coverage: Every 12 hours
• License Utilization: Every 24 hours
• Device Compliance: Every 4 hours
• Email Security: Every 24 hours
• Backup Status: Every 1 hour
• Sync Health: Real-time