FOCUS Specification

2.13.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.13.2 Directly Dependent Columns

Consumed Quantity Consumed Unit Resource ID SKU ID

2.13.3 Supporting Columns

Charge Category Charge Period End Charge Period Start Provider Service Name

2.13.4 Example SQL Query

Example SQL Query

SELECT
  ProviderName,
  ServiceName,
  ResourceId,
  SkuId,
  ConsumedUnit,
  SUM(ConsumedQuantity) AS TotalQuantity
FROM focus_data_table
WHERE ChargeCategory='Usage'
  AND ChargePeriodStart >= ? AND ChargePeriodEnd <= ?
GROUP BY
  ProviderName,
  ServiceName,
  ResourceId,
  SkuId,
  ConsumedUnit

2.13 Resource Usage

2.13.1 Description

2.13.2 Directly Dependent Columns

2.13.3 Supporting Columns

2.13.4 Example SQL Query

Example SQL Query