Identify unused capacity reservations

Asset Library / FinOps Use Cases / Identify unused capacity reservations

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 Columns

Charge Period Start
Charge Period End
Provider
Billing Account ID
Capacity Reservation ID
Capacity Reservation Status
Billed Cost
Effective Cost

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,
  CapacityReservationStatus

Related KPIs

Effective Savings Rate Percentage

Return on investment metric of all commitment discounts by commitmentDiscountId / commitmentDiscountName, commitmentDiscountStatus, commitmentDiscountType, etc..

Formula

Option 1: (CB Discount Savings – Cost to achieve CB Discount Savings) / Compute On-Demand Equivalent Spend
Option 2: 1 – (Actual Spend with Discounts / Equivalent Spend at On Demand Rate)

Data Sources: