aggregated_cost_for_billing_period_by_management_groups

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

Overview

Name	aggregated_cost_for_billing_period_by_management_groups
Type	Resource
Id	azure.consumption.aggregated_cost_for_billing_period_by_management_groups

Fields

vw_aggregated_cost_for_billing_period_by_management_groups

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
billingPeriodName	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_cost_for_billing_period_by_management_groups

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	SELECT	billingPeriodName, managementGroupId	Provides the aggregate cost of a management group and all child management groups by specified billing period

SELECT examples

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

vw_aggregated_cost_for_billing_period_by_management_groups

SELECT
id,
name,
azure_charges,
billingPeriodName,
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_cost_for_billing_period_by_management_groups
WHERE billingPeriodName = '{{ billingPeriodName }}'
AND managementGroupId = '{{ managementGroupId }}';

aggregated_cost_for_billing_period_by_management_groups

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