Identify unused capacity reservations
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
FOCUS Versions
v1.1
v1.2
Context
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).
FOCUS SQL Query
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,
CapacityReservationStatusFOCUS Datasets
FOCUS Columns
Related Capabilities
Related Personas
Related KPIs
Effective Average Compute Cost per Core
Track average cost, after amortization of unused commitment discounts, of each Core per calendar month.
Effective Savings Rate Percentage
Return on investment metric of all commitment discounts.
Percent of Unused Resources
Measure of unused cloud resources, e.g., unattached storage volumes, load balancers, EIPS, and more.