usage_aggregates

Creates, updates, deletes, gets or lists a usage_aggregates resource.

Overview

Name	usage_aggregates
Type	Resource
Id	azure_extras.commerce.usage_aggregates

Fields

Name	Datatype	Description
id	string	Unique Id for the usage aggregate.
name	string	Name of the usage aggregate.
properties	object	Describes a sample of the usageAggregation.
type	string	Type of the resource being returned.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	reportedEndTime, reportedStartTime, subscriptionId	Query aggregated Azure subscription consumption data for a date range.

SELECT examples

Query aggregated Azure subscription consumption data for a date range.

SELECT
id,
name,
properties,
type
FROM azure_extras.commerce.usage_aggregates
WHERE reportedEndTime = '{{ reportedEndTime }}'
AND reportedStartTime = '{{ reportedStartTime }}'
AND subscriptionId = '{{ subscriptionId }}';