Identify unused capacity reservations

FOCUS Versions

v1.3 v1.4

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
  ServiceProviderName,
  BillingAccountId,
  CapacityReservationId,
  CapacityReservationStatus,
  SUM(BilledCost) AS TotalBilledCost,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ?
  AND CapacityReservationStatus = 'Unused'
GROUP BY
  ServiceProviderName,
  BillingAccountId,
  CapacityReservationId,
  CapacityReservationStatus,
  CommitmentDiscountStatus

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail

FOCUS Columns

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

Previous Identify anomalous daily spending by subaccount, region, and service Next Calculate consumption of virtual currency within a billing period