aggregated_costs

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

Overview

Name	aggregated_costs
Type	Resource
Id	azure.consumption.aggregated_costs

Fields

vw_aggregated_costs

Name	Datatype	Description
id	text	The full qualified ARM ID of an event.
name	text	The ID that uniquely identifies an event.
azure_charges	text	field from the properties object
billing_period_id	text	field from the properties object
charges_billed_separately	text	field from the properties object
children	text	field from the properties object
currency	text	field from the properties object
etag	text	The etag for the resource.
excluded_subscriptions	text	field from the properties object
included_subscriptions	text	field from the properties object
managementGroupId	text	field from the properties object
marketplace_charges	text	field from the properties object
tags	text	Resource tags.
type	text	Resource type.
usage_end	text	field from the properties object
usage_start	text	field from the properties object

aggregated_costs

Name	Datatype	Description
id	string	The full qualified ARM ID of an event.
name	string	The ID that uniquely identifies an event.
etag	string	The etag for the resource.
properties	object	The properties of the Management Group Aggregated Cost.
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get_by_management_group	SELECT	managementGroupId	Provides the aggregate cost of a management group and all child management groups by current billing period.

SELECT examples

Provides the aggregate cost of a management group and all child management groups by current billing period.

vw_aggregated_costs

SELECT
id,
name,
azure_charges,
billing_period_id,
charges_billed_separately,
children,
currency,
etag,
excluded_subscriptions,
included_subscriptions,
managementGroupId,
marketplace_charges,
tags,
type,
usage_end,
usage_start
FROM azure.consumption.vw_aggregated_costs
WHERE managementGroupId = '{{ managementGroupId }}';

aggregated_costs

SELECT
id,
name,
etag,
properties,
tags,
type
FROM azure.consumption.aggregated_costs
WHERE managementGroupId = '{{ managementGroupId }}';