2.19 Resource Usage
Since:
1.0
2.19.1 Description
FOCUS enables tracking of resource consumption by providing information about which resources were used, in what quantities, and with what units of measure.
2.19.2 Directly Dependent Columns
2.19.3 Supporting Columns
2.19.4 Example SQL Query
Example SQL Query
SELECT
ServiceProviderName,
ServiceName,
ResourceId,
SkuId,
ConsumedUnit,
SUM(ConsumedQuantity) AS TotalQuantity
FROM focus_data_table
WHERE ChargeCategory='Usage'
AND ChargePeriodStart >= ? AND ChargePeriodEnd <= ?
GROUP BY
ServiceProviderName,
ServiceName,
ResourceId,
SkuId,
ConsumedUnit