Identify unused capacity reservations
Identify all data in a time period where CapacityReservationStatus is ‘unused’ thus identifying capacity reservations that aren’t used and enabling the Practitioner to take action on either cancelling the reservation (if able), working with other personas on a workload that could use the reservation, or performing informed ignore (knowing it is there but ignoring it because there is nothing one can do).
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.1, v1.2
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
Identify unused capacity reservations
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
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
Columns used
Column names from the source use case.