Identify Eligible Capacity Reservation Spend
Identifies charges eligible for capacity-reservation commitment programs, distinguishing between used and unused reservations. Capacity reservations secure resource availability rather than provide discounts, and are tracked via CapacityReservationId and CapacityReservationStatus rather than the commitment discount columns. Filters CommitmentProgramEligibilityDetails to rows whose ProgramType values correspond to capacity-reservation programs (e.g., AdvanceResourceCommitment, ZonalResourceCommitment), then uses CapacityReservationId and CapacityReservationStatus to determine reservation utilization.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.4
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Identify Eligible Capacity Reservation Spend
Not in v1.0 sample- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
CommitmentProgramEligibilityDetails (with its CommitmentPrograms ProgramType entries) and CapacityReservationStatus are absent from the v1.0 sample, so capacity-reservation-eligible spend cannot be identified.
Original FOCUS SQL
SELECT
CU.ServiceProviderName,
CU.ServiceName,
JSON_VALUE(CP, '$.ProgramType') AS EligibleProgramType,
CU.CapacityReservationStatus,
SUM(CU.BilledCost) AS BilledCost,
COUNT(*) AS RowCount
FROM focus_data_table CU
CROSS JOIN
UNNEST(JSON_EXTRACT_ARRAY(CU.CommitmentProgramEligibilityDetails, '$.CommitmentPrograms')) AS CP
WHERE CU.ChargePeriodStart >= ? AND CU.ChargePeriodEnd < ?
AND CU.ChargeCategory = 'Usage'
AND CU.CommitmentProgramEligibilityDetails IS NOT NULL
AND JSON_VALUE(CP, '$.ProgramType') IN ('AdvanceResourceCommitment', 'ZonalResourceCommitment')
GROUP BY
CU.ServiceProviderName,
CU.ServiceName,
JSON_VALUE(CP, '$.ProgramType'),
CU.CapacityReservationStatus
ORDER BY BilledCost DESCColumns used
Column names from the source use case.