Compare resource usage month over month
This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.
FOCUS Versions
v1.0
v1.1
v1.2
Context
FinOps Practitioners can compare usage and costs across charge periods to identify changes in usage month over month.
FOCUS SQL Query
SELECT
MONTH(ChargePeriodStart),
ProviderName,
ServiceName,
ResourceId,
SkuId,
ConsumedUnit,
SUM(ConsumedQuantity) AS TotalConsumedQuantity
FROM focus_data_table
WHERE ChargeCategory='Usage'
AND ChargePeriodStart >= ? and ChargePeriodEnd < ?
GROUP BY
MONTH(ChargePeriodStart),
ProviderName,
ServiceName,
ResourceId,
SkuId,
ConsumedUnitFOCUS Datasets
FOCUS Columns
Related Capabilities
Related Personas
Related KPIs
Total Unpredicted Variance of Spend
Measures the unpredicted variance of cost associated with CSP Cloud usage recorded over a given period of time.
Power Schedule Adherence Rate
Measures the practice of autoscalers or schedulers, or modifying the power state of virtual machines (VMs) or other cloud resources.
Percentage Resource Utilization
Measure of cloud compute resource utilization, e.g. Compute (EC2), Block Storage (EBS), or Object Storage (S3).
Percentage of Legacy Resource
Measure of the percentage of resources running on ‘modern’ types (e.g. instance types, volume type).
Percent Storage on Frequent Access Tier
Measure of the percent of object storage stored on a Frequent Access Tier.
Percent of Unused Resources
Measure of unused cloud resources, e.g., unattached storage volumes, load balancers, EIPS, and more.
Auto-scaling Efficiency Rate
Measures effectiveness of an auto-scaling system.
Anomaly-Detected Cost Avoidance
Measures amount of cost avoidance as a result of identifying and correcting an anomaly.