Identify unused capacity reservations
Inspect the result, its parameters and the SQL behind it.
- Source
- FOCUS use-case library
- Data
- FOCUS 1.0 sample
- Status
- Not in v1.0 sample
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
CapacityReservationId and CapacityReservationStatus are absent from the v1.0 sample, so unused capacity reservations cannot be identified.
Original FOCUS SQL
SELECT ProviderName, BillingAccountId, CapacityReservationId, CapacityReservationStatus, SUM(BilledCost) AS TotalBilledCost, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ? AND CapacityReservationStatus = 'Unused' GROUP BY ProviderName, BillingAccountId, CapacityReservationId, CapacityReservationStatus