Identify Unused Commitments v1.3

Source: FOCUS 1.0 sample
Result rows: 1
Status: Adapted to v1.0
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Lists commitment discounts with Unused status in the period and their billed and effective cost. The sample has a single unused Microsoft compute savings plan with zero cost; commitment_discount_name is added as a readable label.

Column adaptations (1)

Unused commitments

Query results
Charge period start	Charge period end	Service provider name	Billing account id	Commitment discount id	Commitment discount name	Commitment discount type	Commitment discount status	Total billed cost	Total effective cost
2026-03-17	2026-03-18	Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	/providers/Microsoft.BillingBenefits/savingsPlanOrders/802a9e8b-e860-4d5f-b63b-c5bdf7ee2446/savingsPlans/09ff8291-64ac-45fb-afed-b9b39dbd88d7	Compute_SavingsPlan_11-07-2022_09-55	Savings Plan	Unused	$0.00	$0.00

1 row. Scroll inside the table to see more.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select min(charge_period_start) as charge_period_start,
       max(charge_period_end) as charge_period_end,
       case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
       billing_account_id as billing_account_id,
       commitment_discount_id as commitment_discount_id,
       commitment_discount_name as commitment_discount_name,
       commitment_discount_type as commitment_discount_type,
       commitment_discount_status as commitment_discount_status,
       sum(billed_cost) as total_billed_cost,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
  and charge_period_end < $2::timestamptz
  and commitment_discount_status = 'Unused'
group by 3, 4, 5, 6, 7, 8
order by total_effective_cost desc nulls last, commitment_discount_id
limit 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT
  MIN(ChargePeriodStart) AS ChargePeriodStart,
  MAX(ChargePeriodEnd) AS ChargePeriodEnd,
  ServiceProviderName,
  BillingAccountId,
  CommitmentDiscountId,
  CommitmentDiscountType,
  CommitmentDiscountStatus,
  SUM(BilledCost) AS TotalBilledCost,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ?
  AND CommitmentDiscountStatus = 'Unused'
GROUP BY
  ServiceProviderName,
  BillingAccountId,
  CommitmentDiscountId,
  CommitmentDiscountType,
  CommitmentDiscountStatus

Charge period start

Charge period end

Service provider name

Billing account id

Commitment discount id

Commitment discount name

Commitment discount type

Commitment discount status

Total billed cost

Total effective cost

2026-03-17

2026-03-18

Microsoft

/providers/Microsoft.Billing/billingAccounts/8611537

/providers/Microsoft.BillingBenefits/savingsPlanOrders/802a9e8b-e860-4d5f-b63b-c5bdf7ee2446/savingsPlans/09ff8291-64ac-45fb-afed-b9b39dbd88d7

Compute_SavingsPlan_11-07-2022_09-55

Savings Plan

Unused

$0.00

select min(charge_period_start) as charge_period_start, max(charge_period_end) as charge_period_end, case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name, billing_account_id as billing_account_id, commitment_discount_id as commitment_discount_id, commitment_discount_name as commitment_discount_name, commitment_discount_type as commitment_discount_type, commitment_discount_status as commitment_discount_status, sum(billed_cost) as total_billed_cost, sum(effective_cost) as total_effective_cost from focus.cost_and_usage where charge_period_start >= $1::timestamptz and charge_period_end < $2::timestamptz and commitment_discount_status = 'Unused' group by 3, 4, 5, 6, 7, 8 order by total_effective_cost desc nulls last, commitment_discount_id limit 500

SELECT MIN(ChargePeriodStart) AS ChargePeriodStart, MAX(ChargePeriodEnd) AS ChargePeriodEnd, ServiceProviderName, BillingAccountId, CommitmentDiscountId, CommitmentDiscountType, CommitmentDiscountStatus, SUM(BilledCost) AS TotalBilledCost, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ? AND CommitmentDiscountStatus = 'Unused' GROUP BY ServiceProviderName, BillingAccountId, CommitmentDiscountId, CommitmentDiscountType, CommitmentDiscountStatus