Identify resources with shared cost allocation

FOCUS Versions

v1.3 v1.4

Context

Find all resources that have costs split across multiple workloads or consumers, such as shared Kubernetes clusters or multi-tenant databases, to enable accurate chargeback.

FOCUS SQL Query

SELECT
  DISTINCT ResourceId,
  ResourceName,
  AllocatedMethodId
 FROM focus_data_table
 WHERE ChargeCategory='Usage'
  AND ChargePeriodStart >= ? AND ChargePeriodEnd <= ?
  AND AllocatedMethodId IS NOT NULL
 ORDER BY ResourceId