aggregated_costs

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

Overview

Name	aggregated_costs
Type	Resource
Id	azure.consumption.aggregated_costs

Fields

The following fields are returned by SELECT queries:

get_by_management_group

OK. The request has succeeded.

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	The properties of the Management Group Aggregated Cost. (title: Management Group Aggregated Cost properties)
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

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

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
managementGroupId	string	Azure Management Group ID.
$filter	string	May be used to filter aggregated cost by properties/usageStart (Utc time), properties/usageEnd (Utc time). The filter supports 'eq', 'lt', 'gt', 'le', 'ge', and 'and'. It does not currently support 'ne', 'or', or 'not'. Tag filter is a key value pair string where key and value is separated by a colon (:).

SELECT examples

get_by_management_group

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

SELECT
id,
name,
properties,
type
FROM azure.consumption.aggregated_costs
WHERE managementGroupId = '{{ managementGroupId }}' -- required
AND $filter = '{{ $filter }}'
;