Analyze total cost by allocated resource
Aggregate effective cost by allocated resource ID to understand actual consumption costs for individual workloads or namespaces within shared infrastructure.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.3, v1.4
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Analyze Total Cost by Allocated Resource
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, AllocatedResourceId and AllocatedResourceName (v1.3+ allocation columns) are absent from the v1.0 sample, so allocated-resource costs cannot be derived.
Original FOCUS SQL
SELECT AllocatedResourceId, AllocatedResourceName, ResourceId AS OriginResourceId, SUM(EffectiveCost) AS TotalEffectiveCost, COUNT(*) AS ChargeCount FROM focus_data_table WHERE ChargeCategory='Usage' AND ChargePeriodStart >= ? AND ChargePeriodEnd <= ? AND AllocatedMethodId IS NOT NULL AND AllocatedResourceId IS NOT NULL GROUP BY AllocatedResourceId, AllocatedResourceName, ResourceId ORDER BY TotalEffectiveCost DESC
Columns used
Column names from the source use case.