Identify resources with shared cost allocation
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.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.3, v1.4
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Identify Resources With Shared Cost Allocation
Not in v1.0 sample- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
AllocatedMethodId (v1.3+ allocation column) is absent from the v1.0 sample, so resources with shared cost allocation cannot be identified.
Original FOCUS SQL
SELECT DISTINCT ResourceId, ResourceName, AllocatedMethodId FROM focus_data_table WHERE ChargeCategory='Usage' AND ChargePeriodStart >= ? AND ChargePeriodEnd <= ? AND AllocatedMethodId IS NOT NULL ORDER BY ResourceId
Columns used
Column names from the source use case.